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

MOSC Banner

NOT ALLOWED status in SWITCHOVER_STATUS after reinstating the dataguard setup

 
  Dear Experts, 

     Oue 11gR2 database on Windows 2008 R2 is running on a DG setup with FSFO setup. Due to sudden crash in our Primary database, Primary got failed over to Standby. 

    Immediately using DGBroker we reinstanted the Primary database(original) to make it the secondary. IN the next weekend we switched the configuration back to its original configoration. However we observed a strange thing as below in our standby database

     SQL> SELECT DATABASE_ROLE, SWITCHOVER_STATUS FROM V$DATABASE;

           DATABASE_ROLE    SWITCHOVER_STATUS
                  ----------------         --------------------
          PHYSICAL STANDBY      NOT ALLOWED

   In The primary the query results in 

  SQL> SELECT DATABASE_ROLE, 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