Time for action – switchover with a logical standby using broker
Perform the following steps to change the roles of the primary and logical standby databases:
Check the configuration of Data Guard. In the broker's configuration, we have one primary database and one logical standby database already configured. Ensure that the status is
SUCCESS
before performing a switchover as shown in the following code:DGMGRL> show configuration; Configuration - PACKT Protection Mode: MaxPerformance Databases: INDIA_UN - Primary database turkey_un - Logical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS
Perform a switchover using the DGMGRL command. Before performing switchover, connect to the DGMGRL utility using the complete username and password of the
SYS
user instead of connecting with/
as shown in the following code:DGMGRL> connect sys/******* Connected.
Once authenticated, initiate the switchover with the following command as shown in the screenshot...