Time for action – switchover with a physical standby using EM Cloud Control
Assuming a Cloud Control installation and Data Guard integration is already set up, perform the following steps on the Cloud Control interface.
On the Data Guard Administration home page, click on Switchover as shown in the following screenshot:
Enter credentials to connect the standby and primary hosts.
On the confirmation page, click on Yes to start the switchover. At the bottom of the screen, check Swap Monitoring Settings if you want the current Enterprise Manager monitoring settings (including metric thresholds) for the primary and standby databases to be swapped after the role change, as shown in the following screenshot:
We'll see the switchover processing window on the next screen. A notification will appear, Switchover completed successfully, when the process is completed successfully. The following screenshot is the processing screen:
Tip
Similarly, we can use the Failover button on the Data Guard Administration home page to initiate a failover.
Performing switchover with a logical standby database using SQL*Plus
So far we have explained the switchover procedure between primary and physical standby databases. In the same manner, we can perform a switchover between the primary database and the logical standby database. However, there are some differences in this operation.
Tip
For versions above 11g, there's no need to shut down either the primary or the logical standby database for a switchover.