archived redo logs and standby db

[wagen wheels]

Hi,

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

SWITCHOVER_STATUS
--------------------
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

[Steve Howard]

Hi Wagen,

1 - This is how we do it. The only thing I would mention is if the
standby is a cluster you will also have to filter on thread.
2 - You cannot have any logins on the standby database to switchover.
You can do a "with session shutdown" clause to disconnect them.

HTH,

Steve

[wagen wheels]

Thanks Steve.

Reg 2 - I have the db in managed recovery (did not open in READ ONLY)
with no logins and i still see SWITCHOVER_STATUS showing "NOT
ALLOWED".

Is there a way in oracle (10g/11g) where oracle can automatically
delete the standby archived redo log if it is successfully applied.
Trying not to write a script if there is something built in. I checked
the docs/web didn't find anything so far.

Thanks for any pointers/help.