Switchover

A switchover reverses the primary and standby database roles. Each database continues to participate in the Oracle Data Guard association in its new role. A switchover ensures no data loss. You can use a switchover before you perform planned maintenance on the primary database. Performing planned maintenance on a DB system with an Oracle Data Guard association is typically done by switching the primary database to the standby role, performing maintenance on the standby database, and then switching it back to the primary role.

Failover

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 on the primary database to perform a switchover using the OCI Console:

You initiate a switchover operation by using the Data Guard association of the primary database.

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 associations tab.
4. For the Data Guard association on which you want to perform a switchover, from the Actions menu, select Switchover.
5. In the Switchover database panel, enter the database admin password, and then select Ok.

   This database should now assume the role of the standby, and the standby should assume the role of the primary in the Data Guard association.

Procedure

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

You initiate a failover operation by using the Data Guard association of the standby database.

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 associations tab.
4. For the Data Guard association 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 Ok.

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