Not Allowed Status DG Switchover

Hi,

I'm testing DG switchover with physical standby and i was able to switch primary to standby without any problems. however after switchover, query on standby (suppose to be primary before), gave me the fol output.

SQL> select force_logging,remote_archive,switchover_status,dataguard_broker from v$database;

FOR REMOTE_A SWITCHOVER_STATUS DATAGUAR
--- -------- -------------------- --------
YES ENABLED NOT ALLOWED DISABLED query on primary (suppose to be standby before)

FORCE_LOGGING REMOTE_ARCHIVE SWITCHOVER_STATUS

                  DATAGUARD_BROKER


------------- --------------

------------------------------------------------------------

----------------

YES           ENABLED        TO STANDBY
                  DISABLED

I've verified that logs gets shipped/applied on standby from primary after switchover. No sequence gaps etc. Wondering, why switchover_status still has "NOT ALLOWED' on the standby database, when it suppose to have "TO PRIMARY"

Any pointers is much appreicated.

Thanks,
Stalin

Platform : 10g EE (10.1.0.4), Solaris 2.9
--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 19 2005 - 18:04:59 CDT