Reinstating a Failed Primary Database using Dataguard Broker

Reinstating a Failed Primary Database using Dataguard Broker

Details :

DETAILS	SOURCE	TARGET
IP_ADDRESS	192.168.1.44	192.168.1.37
SERVER_NAME	PRIMARY	STANDBY
DB_VERSION	12.2.0.1	12.2.0.1
DB_NAME	DELL	STANDBY

The Primary Database DELL is failed already and the STANDBY database is acts as NEW PRIMARY database .We are going to REINSTATE the failed Primary database.

FLASHBACK :

During Reinstate the Failed Primary will be flasback and act as a physical standby database , then the media recovery process will be started automatically.

For Reinstate the FLASHBACK DATABASE must be enabled .

 

 

 

If the flashback is not enabled , Enable the flashback database .

ALTER DATABASE FLASHBACK ON;

CHECK THE DATABASE STATUS IN DG_BROKER : 

 

 

 

 

 

 

 

PERFORMING REINSTATE

CONNECT TO DG_BROKER AND ISSUE THE COMMAND REINSTATE

 

 

 

 

 

Show Configuration to verify 

Check the database status

The database has been reinstated as physical standby.