Dataguard Failover Using DGMGRL

Failover is an irreversible transition of a standby database to the primary role.
This is only done in the event of a catastrophic failure of the primary database

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 PROD STANDBY

LOGIN TO STANDBY SIDE :

 

 

 

 

SHOW CONFIGURATION command to verify the failover.

Check the Standby is ready to become a new Primary using the VALIDATE command .

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Connect to standby database :

 

 

 

 

Issue the Fail Over command in Standby to become the new Primary database.

 

 

Verify the Configuration it is changed or not .

Recommended Posts

Start typing and press Enter to search