Reinstate the failed Primary as Standby Using Broker (DGMGRL)

<<Back to Oracle DataGuard Main Page

How to Reinstate the failed Primary as Standby Using Broker (DGMGRL)- Without Rebuilding

Set the correct environment and issue the following command while connected to any database in the broker configuration, except the database that is to be reinstated:

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)