Using FLASHBACK to Reinstate a Standby after a FAILOVER

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

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?