Using FLASHBACK after a Data Guard Failover

Posted by Gavin Soorma
On June 28, 2009
0 Comments

Original Data Guard Environment HQLINUX05 - PRIMARY ITLINUX03 - STANDBY. Perform FAILOVER TO ITLINUX03 (now the new Primary) Next in ITLINUX03 ..... Step 1: On the new primary, run the following query to determine at what SCN it became the new primary. bozo:/u01/ORACLE/bozo> sql SQL*Plus: Release 10.1.0.2.0 - Production on Mon May 9 14:48:57 2005 […]

Posted by Gavin Soorma
On June 25, 2009
0 Comments

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 […]

News

Using FLASHBACK after a Data Guard Failover

Using FLASHBACK to Reinstate a Standby after a FAILOVER