June 2013
Beginner
404 pages
9h 40m
English
Now we will see a step-by-step approach to perform a switchover between the primary and the logical standby database:
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
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.