Intermittently appearing user session and performing switchover operation
Hello everyone
We have a 11g R2 primary and physical standby database on Windows 2008 Server
We are testing switchover process and as part of the process, we executed the following verification steps / tasks
1) On Primary Database
SQL> select status, gap_status from v$archive_dest_status where dest_id = 2;
STATUS GAP_STATUS
--------- ------------------------
VALID NO GAP
2) We verified that there are TEMP files associated with TEMP tablespace on both the primary and standby databases
3) select delay_mins from v$archive_dest where dest_id = 2;
DELAY_MINS
----------
0
4) Verify that the primary database could be switched to Standby database
SQL> select switchover_status from v$database;