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:
- Check the switchover status of the primary database. Ensure that the status is either
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
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.
- Prepare the primary database for switchover. Execute the following command from ...