Re: Archive logs & physical standby

From: David Lord <>
Date: Fri, 21 Mar 2008 19:00:16 +0000
Message-ID: <>

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

Received on Fri Mar 21 2008 - 14:00:16 CDT

Original text of this message