Re: archivelogs scheduling

  • From: Oscar Ofiana <oj.ofiana@xxxxxxxxx>
  • To: pdba1966@xxxxxxxxxxx
  • Date: Tue, 22 Feb 2011 09:02:50 +0800

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.


On Tue, Feb 22, 2011 at 8:27 AM, P D <pdba1966@xxxxxxxxxxx> 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?

Other related posts: