Re: RMAN -- delete older archivelogs

Kanwar,

Retention policy is different from what you are actually asking now. Retention policy makes the backups state in the catalog/controlfile as 'obsolete' , prior to retention period , but, doesn't actually delete them until you execute delete obsolete command from the RMAN. See if the following can fit into your requirement:

BACKUP ARCHIVELOG ALL NOT BACKUPED UP 1 TIMES; DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-16/24';

Jaffar

On 6/4/07, 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
>
>
>

-- 
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."

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