Perform Database Failover

You initiate a failover operation on a standby database that is a member of the Data Guard configuration.

A failover transitions the standby database into the primary role after the existing primary database fails or becomes unreachable. A failover might result in some data loss when you use Maximum Performance protection mode.

Procedure

Perform the following steps to perform a failover using the OCI Console:

  1. On the DB Systems list page, select the DB system that contains the database that you want to work with. If you need help finding the list page or the DB system, see List the DB Systems.
  2. On the Databases tab, select the database that you want to work with.
  3. On the database details page, select the Data Guard Group tab.
  4. For the standby database on which you want to perform a failover, from the Actions menu, select Failover.
  5. In the Failover database panel, enter the database admin password, and then select Failover.

This database should now assume the role of the primary, and the old primary’s role should display as Disabled standby.