PERFORM A FAILOVER USING DATA GUARD BROKER DGMGRL> failover to 'standby_blade07'; Performing failover NOW, please wait... Failover succeeded, new primary is "standby_blade07" On the NEW PRIMARY issue this command to obtain the SCN to FLASHBACK the old primary(new standby) to SQL> conn / as sysdba Connected. SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE; TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) ---------------------------------------- 2147132 FLASHBACK THE OLD PRIMARY AND CONVERT IT TO A PHYSICAL STANDBY SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 574619648 bytes Fixed Size 2022408 bytes Variable Size 327156728 bytes Database Buffers 239075328 bytes Redo Buffers 6365184 bytes Database mounted. SQL> FLASHBACK DATABASE TO SCN 2147132; Flashback complete. SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY; Database altered. SQL> shutdown immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL> USING DATA GUARD BROKER REINSTATE THE NEW STANDBY DATABASE INTO THE DATA GUARD CONFIGURATION DGMGRL> reinstate database 'streams2';Reinstating database "streams2", please wait... Operation requires shutdown of instance "streams2" on database "streams2" Shutting down instance "streams2"... ORA-01109: database not open Database dismounted. ORACLE instance shut down. Operation requires startup of instance "streams2" on database "streams2" Starting instance "streams2"... ORACLE instance started. Database mounted. Continuing to reinstate database "streams2" ... Reinstatement of database "streams2" succeeded DGMGRL> show configuration; Configuration Name: streams2.hq.emirates.com Enabled: YES Protection Mode: MaxPerformance Fast-Start Failover: DISABLED Databases: streams2 - Physical standby database standby_blade07 - Primary database Current status for "streams2.hq.emirates.com": SUCCESS
The following two tabs change content below.