Oracle 12c Dataguard RAC Primary to RAC Standby with Dataguard Broker (on Exadata)

Setup for the Environment ------------------- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 12.1.0.2 DB Home Version : 12.1.0.2 Primary, 2 Node RAC, db_unique_name = primeprd Instance 2 : primeprd1 Instance 2 : primeprd2 TNS entry: PRIMEPRD, but below entry in tnsnames.ora files on both node with DB Home user, most … Continue reading Oracle 12c Dataguard RAC Primary to RAC Standby with Dataguard Broker (on Exadata)

Oracle Dataguard Broker 12c with password file in ASM

Configure 12c dataguard broker using the below command onPrimary database server primeprd - > tnsnames for primary database primedr-> tnsnames for standby database /home/oracle::11g-->dgmgrl DGMGRL> connect sys/******** DGMGRL> create configuration dg_primeprd as primary database is primeprd connect identifier is primeprd; DGMGRL> add database primedr as connect identifier is primedr maintained as physical; Configuration "dg_primeprd" created … Continue reading Oracle Dataguard Broker 12c with password file in ASM

RMAN — ORA-19909: datafile 1 belongs to an orphan incarnation in a Standby Database.

We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went missing and there was a gap. After doing the restore we got the below error in the RMAN recovery rman nocatalog target sys/******@mw auxiliary / connected to target database: MW (DBID=000000000) using target database control … Continue reading RMAN — ORA-19909: datafile 1 belongs to an orphan incarnation in a Standby Database.

Failed Primary Conversion to Physical Standby

1) Query on old standby database (new primary)SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE;TO_CHAR(STANDBY_BECAME_PRIMARY_SCN)----------------------------------------124966431892) Flash back the failed primary database.SQL> shutdown immediate;SQL> startup mount;SQL> FLASHBACK DATABASE TO SCN 12496643189;Flashback complete.3) Convert old primary into standby databaseSQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY;SQL> SHUTDOWN IMMEDIATE;SQL> STARTUP MOUNT;SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM … Continue reading Failed Primary Conversion to Physical Standby

RAC to Single Instance Standby Database Setup (Oracle 11gR2 Physical Standby)

Primary is a 2 node-rac cluster with instances swx1 and swx2 running on ASM. A service called swxscan is created for client sides. We will use this service name for the tnsnames.ora. The standby instance will be called swxstandby and it will be running single instance on ASM as well. This is a standard dataguard … Continue reading RAC to Single Instance Standby Database Setup (Oracle 11gR2 Physical Standby)