Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN -- delete older archivelogs

Re: RMAN -- delete older archivelogs

From: Kanwar Plaha <kanwar.plaha_at_hp.com>
Date: Mon, 4 Jun 2007 18:58:11 +1000
Message-Id: <200706041858.11229.kanwar.plaha@hp.com>


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
Received on Mon Jun 04 2007 - 03:58:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US