NOT ALLOWED status in SWITCHOVER_STATUS after reinstating the dataguard setup
edited Jul 11, 2013 11:01PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered ✓
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;
0