Re: archivelogs scheduling

From: Oscar Ofiana <oj.ofiana_at_gmail.com>
Date: Tue, 22 Feb 2011 09:02:50 +0800
Message-ID: <AANLkTi=8rsEY-+iOpOQfmXLsq-dx1N=8WYSf8QTES_k5_at_mail.gmail.com>



Hi P D,

Assuming that the script also backs up the archivelogs, you could put something similar to this at the end of the script:

delete noprompt archivelog all backed up 1 times to device type disk completed before 'sysdate-7';

If backed up to tape you can change the type to sbt.

HTH,
OJ

On Tue, Feb 22, 2011 at 8:27 AM, P D <pdba1966_at_hotmail.com> wrote:

> I inherited a system that I only want for there to be 7 days of
> archivelogs kept on the server. The rest should be backed up and removed
> by RMAN. Right now there seems to be several weeks worth of archivelogs
> and I am not sure what the schedule is for them. I looked at the script
> and it doesn't seem to indicate how the logs are being removed or what the
> settings are. Where else should I look? Is there a parameter that needs
> to be alter to be 7 instead?
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 21 2011 - 19:02:50 CST

Original text of this message