Perform a Database Failover

This topic describes how to perform a failover on a database in a Data Guard Group.

Before you begin, review the following:

• You can initiate a failover operation on a standby database that is a member of a Data Guard Group.

• A failover transitions the standby database to the primary role when the current primary database fails or becomes unreachable. If the Data Guard configuration uses Maximum Performance protection mode, a failover might result in some data loss.

• You can also initiate a failover when the primary database is in a healthy state. However, Oracle recommends using a switchover instead of a failover for planned role transitions.

Procedure

Perform the following steps in the Console.

1. On the Data Infrastructures list page, select the Data Infrastructure that you want to work with. If you need help finding the list page or the Data Infrastructure, see List Data Infrastructures.

2. On the Data Infrastructure details page, select the VM Cluster tab to view the list of all VM Clusters.
3. On the VM Clusters tab, select the VM Cluster that you want to work with.

4. On the VM Cluster details page, select the Databases tab to view the list of all databases.

5. On the Databases tab, select the Database that you want to work with.

6. On the Database details page, select Data Guard Group.

7. For the standby database you want to failover, select the Actions icon (three dots), and select Failover.

After the failover completes successfully, the standby database assumes the primary role, and the former primary database is displayed with the Disabled Standby status.