Re: Archive logs & physical standby

There is an 'Oracle' way (in 10.2 at least, I haven't checked earlier versions): keep your archivelogs in a flash recovery area and set the RMAN command CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY. Regards
David Lord

On 21/03/2008, Andy Rivenes <arivenes_at_llnl.gov> wrote:
>
> As far as I know, up through at least 10g R2, there is no "Oracle" way to
> delete archived log files that have been applied to the standby. I built a
> script to do this that you're welcome to use however. It's called
> "stby_maint" and has proven reliable for the systems that I've used it on.
> I've made it available as open source on SourceForge.net -
> http://orautil.sourceforge.net. Unfortunately it's not real well documented
> except in the header of the code, but it's just a korn shell script so you
> should be able to figure it out. Someday I will get around to creating a
> user manual for it, but it is available if you want to take a look at it.
>
>
> Andy Rivenes
>
>
>
>

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