Re: Archive logs & physical standby

  • From: "David Lord" <dlordster@xxxxxxxxx>
  • To: arivenes@xxxxxxxx
  • Date: Fri, 21 Mar 2008 19:00:16 +0000

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@xxxxxxxx> 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
>
>
>
>
--
//www.freelists.org/webpage/oracle-l


Other related posts: