Re: archivelogs scheduling
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-lReceived on Mon Feb 21 2011 - 19:02:50 CST