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.

  1. On the Data Guard Administration home page, click on Switchover as shown in the following screenshot:
    Time for action – switchover with a physical standby using EM Cloud Control
  2. Enter credentials to connect the standby and primary hosts.
  3. 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:
    Time for action – switchover with a physical standby using EM Cloud Control
  4. 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:
    Time for action – switchover with a physical standby using EM Cloud Control

    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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.143.254.90