Re: Dataguard Archive Logs

You can go ahead and delete the archived logs on the standby.
If you are Linux I can give you a cron job. .
On 6 January 2011 16:50, Patrick Elliott <elliotp1@xxxxxxx> wrote:

> I am referring to archive logs on the standby database not on the primary
> database. I do not want to delete archive logs on the primary. I want to
> delete the archive logs on the standby.
>
>
>
> *Patrick Elliott
> *"You don't truly fail until you quit."
>
>
>
>
> > Subject: Re: Dataguard Archive Logs
> > To: elliotp1@xxxxxxx
> > CC: oracle-l@xxxxxxxxxxxxx
> > From: Laimutis.Nedzinskas@xxxxxx
> > Date: Thu, 6 Jan 2011 17:26:25 +0200
>
> >
> > if you want Oracle to do auto-magic for you then try rman archive log
> > delete policy. archive logs must be in oracle flashback recovery area.
> >
> > rman> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
> >
> > then search metalink for one hidden parameter, I think
> > *._log_deletion_policy='ALL'.
> >
> >
> >
> >
> >
> >
> >
> >
> ---------------------------------------------------------------------------------
> >
> > Please consider the environment before printing this e-mail
> >
> >
> >
> > Patrick Elliott
> > <elliotp1@xxxxxxx
> > > To
> > Sent by: <oracle-l@xxxxxxxxxxxxx>
> > oracle-l-bounce@f cc
> > reelists.org
> > Subject
> > Dataguard Archive Logs
> > 2011.01.06 16:36
> >
> >
> > Please respond to
> > elliotp1@xxxxxxx
> >
> >
> >
> >
> >
> >
> > I have a physical dataguard database on a development system in
> > noarchivelog mode. The archive log directory keeps filling up. Since it
> is
> > development, I do not need to keep the archive logs. They are already
> > backed up on the production database. How do I get the dataguard database
> > to stop archiving?
> >
> > Patrick Elliott
> > "You don't truly fail until you quit."
> >
>



-- 
Howard A. Latham

Sent from my Nokia N97

Other related posts: