10g Data Guard Broker Fast Start Failover

FAST START FAILOVER IS DISABLED BY DEFAULT Configuration Name: streams2.hq.emirates.com Enabled: YES Protection Mode: MaxAvailability Fast-Start Failover: DISABLED Databases: streams2 – Primary database blade08 – Physical standby database Current status for “streams2.hq.emirates.com”: SUCCESS PREPARE TO ENABLE TO FAST START FAILOVER DGMGRL> EDIT DATABASE ‘streams2’ SET PROPERTY FastStartFailoverTarget = ‘blade08’; Property “faststartfailovertarget” updated DGMGRL> EDIT DATABASE […]

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 ?