Oracle Data Guard 11gR2 Administration Beginner's Guide

Time for action – switchover with a logical standby database using SQL*Plus

Now we will see a step-by-step approach to perform a switchover between the primary and the logical standby database:

1. Check the switchover status of the primary database. Ensure that the status is either TO STANDBY or SESSIONS ACTIVE; if so, you are safe to perform a switchover as shown in the following code:

   SQL> select switchover_status from v$database;
   SWITCHOVER_STATUS
   --------------------
   TO STANDBY

   Note

   In case of RESOLVABLE GAP, wait until SQL was applied on the logical standby database; for other statuses, troubleshoot and fix the synchronization for the switchover process to be successful.

2. Prepare the primary database for switchover. Execute the following command from ...