Not Allowed Status DG Switchover
- From: Stalin <stalinsk@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 19 Sep 2005 16:02:47 -0700
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
- Follow-Ups:
- Re: Not Allowed Status DG Switchover
- From: Carel-Jan Engel
Other related posts:
- » Not Allowed Status DG Switchover
- » Re: Not Allowed Status DG Switchover
- » Re: Not Allowed Status DG Switchover
- » Re: Not Allowed Status DG Switchover
- » Re: Not Allowed Status DG Switchover
- Re: Not Allowed Status DG Switchover
- From: Carel-Jan Engel