High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center