Re: RMAN -- delete older archivelogs

From: Asif Momen <asif_oracle_at_yahoo.com>
Date: Mon, 4 Jun 2007 07:14:10 -0700 (PDT)
Message-ID: <112099.12953.qm@web56601.mail.re3.yahoo.com>

Hi Kanwar,

You would use the following in RMAN script:

DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-10/24';

This will cause RMAN to delete all the archivelogs older than 13 hours.

Regards

• Kanwar Plaha <kanwar.plaha_at_hp.com> wrote:

> That's what we are currently doing ...
> ... backup archivelog all delete input;
>
> However, our requirement is that the logs should be
> kept on disk for (say) 13
> hours. How do I do that from within RMAN. Even if
> more than one command is
> required, its alright.
>
> On Mon, 4 Jun 2007 04:41:55 pm Syed Jaffar Hussain
> wrote:
> > Kanwar,
> >
> > If you afraid that archivedlogs will fill up the
> directory, why don't
> > create a script and run the script every 6 hrs. to
> backup the archived logs
> > and delete the backed archivelogs from disk.
> >
> > Jaffar
> >
> > On 6/4/07, Kanwar Plaha <kanwar.plaha_at_hp.com>
> wrote:
> > > Hi,
> > > Due to a backup clashing with one of the
> automated cloning script for a
> > > database, the retention policy
> > > for archivelogs needs to be 12-13 hours. How can
> I set this? Setting
> > > retention to 1 day (which I believe is
> > > the mininum) is too long and I risk the
> archivelog directory filling up.
> > >
> > > The database version is 9.2.0.6.
> > >
> > > Thanks,
> > > Kanwar
> > > --
> > > http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
       

---

Pinpoint customers who are looking for what you sell. http://searchmarketing.yahoo.com/

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

Received on Mon Jun 04 2007 - 09:14:10 CDT