archived redo logs and standby db

From: wagen wheels <>
Date: Wed, 28 Oct 2009 08:57:22 -0700 (PDT)
Message-ID: <>


Oracle11g 11.1.0
Linux (RHEL AS 4.4)

  • Primary and standby db (physical standby with standby redo logs)
  • Standby db in read only mode (haven't setup real time apply yet)
  • Primary: log_archive_dest_2 = LGWR ASYNC

I have two questions

  1. We have a need to delete the archived redo logs on the standby database AFTER it's applied. I plan to use the following query, get the seqence number and then use RMAN to delete the APPLIED archived redo logs that are on disk. select max(sequence#) max_applied_seq from gv$archived_log where applied='YES';
  2. I have setup the standby db as per oracle documentation, logs are being applied and the standby db is in sync with the primary. When I execute the query SELECT SWITCHOVER_STATUS FROM gv$database ; on the STANDBY DB it shows


NOT ALLOWED NOTE: we have read only users connected to the standby db

Why is the switchover_status showing "NOT ALLOWED"? What are the things i should check?

Thanks for your help.
wagen Received on Wed Oct 28 2009 - 10:57:22 CDT

Original text of this message