A switchover reverses the primary and standby database roles. Each database continues to participate in Oracle Data Guard 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 Data Guard 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.

Procedure

Perform the following steps to perform a switchover 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 switchover, from the Actions menu, select Switchover.
5. In the Switchover database panel, enter the database admin password, and then select Switchover.

This database should now assume the role of the primary, and the old primary should assume the role of the standby.

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.