There are various methods (RMAN, Online datafiles move 12c onwards, ASMCMD, DBMS_FILE_TRANSFER, etc) to achieve migrate databases from Non-ASM to ASM. Here we will use two types of RMAN mix …
Oracle
-
-
List of target upgrade versions from supported source version along with the certificate, data source support.oracle.com. Direct Upgrade Version List: Source DB Version Target DB Version 18.1 19c 12.2.0.2 19c 12.1.0.2 19c …
-
Backup&RecoveryOracle
Steps to Clone Oracle Database from Windows to Oracle Linux
by tuanlpby tuanlpIn the previous blog, we sawΒ Steps to create a Heterogeneous Dataguard between Windows and LinuxΒ Click here to read more.Β In this blog, we are going to perform aΒ cloneΒ of Windows Oracle DB …
-
DataguardOracle
Steps to create a Heterogeneous Dataguard between Windows and Linux
by tuanlpby tuanlpHeterogenous Dataguard is a best use case, when we need to perform DB migration from Windows to Linux with minimum downtime as the actual downtime comprises only DB switch. As both Windows and Linux are Little …
-
π‘ While setting up the standby database in Oracle, the archives are not being shipped to the standby and we were continuously getting this alert when queried the V$ARCHIVE_DEST view. …
-
OracleTroubleshoot
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
by tuanlpby tuanlpMake sure that your ORACLE_HOME and ORACLE_SID are correct To see the current values in windows, at the command prompt type echo %ORACLE_HOME% Then echo %ORACLE_SID% If the values are …
-
-
π‘ Recently I tried to setup some new physical standby databases and got the following strange message: DGMGRL> ADD DATABASE “XXXX” as connect identifier is “XXXX” maintained as physical; Error: …
-
OracleTroubleshoot
ORA-16795: the standby database needs to be re-created, Recreate DB Broker
by tuanlpby tuanlp<aside> π‘ The Oracle database has been upgraded from 11.2.0.4 to 12.2.0.1 and the standby database (physical) was able to synchronize the data; but we see the error βORA-16795: the …
-
π‘ After configuring data guard, databases would be either primary and standby database role, and we can altered these roles without loss of data or without resetting logs called Switchover. …