Primary Standby Configuration Oracle 11.2.0.1.0
940673Dec 10 2012 — edited Dec 11 2012Hi All,
I have a primary and physical standby configuration. I am planning a switchover between primary and standby. Both my primary and standby is in sync now and I have done few steps which is mentioned below:-
In Primary:-
SQL> select max(sequence#) from v$log_history;
MAX(SEQUENCE#)
--------------
146
In standby:-
SQL> select max(sequence#) from v$log_history;
MAX(SEQUENCE#)
--------------
146
My Primary database switchover_status is showing "To Standby" but my standby switchover_status is showing "Not Allowed". Please suggest in this circumstance can I go for a switchover. I am waiting for all your inputs.
Regards,
Arijt