Re: How long to keep archive logs?

Janine,

Short answer is "it depends".

How frequently are you taking backups? At the least you must keep archived 
logs from last backup time to current time. If you take backups every 
week, you must keep archived logs for a week. Please make sure your backup 
is successful before deleting old archived logs. I have seen some one had 
that two separate jobs one for taking backup and second for deleting 
archived logs. Backup job failed, but deletion of archived logs succeeded, 
and this is when Murphy may strike.

HTH

- Mayen






"Janine Sisk" <janine@xxxxxxxxxx> 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
Apr 20 2010 03:07 PM
Please respond to
janine@xxxxxxxxxx


To
"oracle-l L" <oracle-l@xxxxxxxxxxxxx>
cc

Subject
How long to keep archive logs?


Here comes another one of those extremely newbie questions...

I have turned on archive logging for the first time, so of course I now 
have large archive log files piling up.

I currently do my backups via the caveman begin/end backup method, because 
it works very well with Amazon EC2's snapshot feature.  I eventually plan 
to implement RMAN backups as well, but have not done it yet.

I have gathered from the reading I have done that archive logs do not need 
to be kept once a backup has been taken, but I'm not sure if that applies 
to the type of backups I'm doing or if it is only true if RMAN is 
involved.  It seems logical that I would not need them;  if I needed to 
recover back to before the last snapshot, I would just restore that and be 
done with it.

Can anyone tell me what a reasonable deletion strategy would be for these 
log files?

thanks,

janine


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

Other related posts: