RE: Q:Clean archives after apply them to standby

If you are running RMAN on the primary RMAN will not delete archive logs on the primary if they are still needed on the standby, see Metalink note 374421.1 and other RMAN/Dataguard documentation. I believe the same is true if running RMAN on the standby but I have not tested this.

As far as removing archive logs on the standby, I just saw documentation on how to do this although I forgot to write it down and a quick search this morning didn't find it, anyone? I believe it is possible to configure RMAN to do this. It is also possible to have the OEM handle this as well. Unfortunately I don't have the documentation at my fingertips but some searching should find it.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Amihay Gonen Sent: Tuesday, January 13, 2009 1:43 AM
To: oracle-l_at_freelists.org
Subject: Q:Clean archives after apply them to standby

Hi , I'm looking for "best practice " advices from the real world.

I've a setup with Primary and standby database (unix solaris , 10.2.0.4) . I want to clean the archives (from primary and standby ) which has been applied successfully  on the standby .

If anyone has an script/pl\sql which has work good for him/her . I would like to hear.

Thanks in advance .

Amihay Gonen,
DBA

--
http://www.freelists.org/webpage/oracle-l