Now we will see a step-by-step approach to perform a switchover between the primary and the logical standby database:
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.