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

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

1. From the navigation menu, select Oracle Database, and then select Oracle Base Database Service.
2. Select your Compartment. A list of DB systems is displayed.
3. On the DB system list page, select the DB system with the primary database you want to switchover. The DB system details page is displayed.
4. On the DB system details page, select the primary database.
5. On the database details page, under Resources, select Data Guard associations.
6. For the Data Guard association on which you want to perform a switchover, from the Actions menu, select Switchover.
7. 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 to perform database failover using the OCI Console:

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

1. From the navigation menu, select Oracle Database, and then select Oracle Base Database Service.
2. Select your Compartment. A list of DB systems is displayed.
3. On the DB system list page, select the DB system with the primary database's peer standby you want to fail over to. The DB system details page is displayed.
4. On the DB system details page, select the standby database.
5. On the database details page, under Resources, select Data Guard associations.
6. For the Data Guard association on which you want to perform a failover, from the Actions menu, select Failover.
7. 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.