How to Reinstate the failed Primary as Standby Using Broker (DGMGRL)- Without Rebuilding
DGMGRL> REINSTATE DATABASE db_unique_name;
The newly reinstated standby database will begin serving as a standby database to the new primary database.
Note:- Flashback must be on and Flashback logs must be accessible for the REINSTATE to succeed. If your database was in no flashback mode before the failover you need to rebuild it manually from current primary
DGMGRL> REINSTATE DATABASE APX1TP;
Reinstating database "APX1TP", please wait...
Oracle Clusterware is restarting database "APX1TP" ...
Continuing to reinstate database "APX1TP" ...
Reinstatement of database "APX1TP" succeeded
DGMGRL> show configuration;
Configuration - APX1T_DG
Protection Mode: MaxAvailability
Members:
APX1TS- Primary database
APX1TP- Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 60 seconds ago)
Comments
Post a Comment