Skip to Main Content
  • Questions
  • Archive log list Generating high in my Production server

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Santhosh.

Asked: October 24, 2016 - 5:17 am UTC

Last updated: October 24, 2016 - 6:27 am UTC

Version: 11.2.0.1

Viewed 1000+ times

You Asked

Hi Tom,

In my Production server generating archivelog files more than 200GB per day. Usually we taking manual backup (OS level move files) of this archive log to another drive for emergency purpose. after that will delete next day. and monthly once we have run job on this same server that time we got more that 800GB archive log that day only. that time will closly monitoring and move this file to another drive or delete this archivelogs some times.

Kindly Give me advise to my below mentioned doubts

1. Is this possible to Auto Move (or) Delete archive log once reached 50GB drive space from 200 GB?
2. after moved the Archive log to another drive that one drive also should full few hours later that also we required to auto delete.

This is very critical which is affected my production also some time.

Regards,
Santhosh.N

and Connor said...

Hopefully you are using RMAN to backup your archives ? Assuming that is the case, you would just run the RMAN backup with the "delete all input" (ensuring that you are meeting your SLA's for number of backups, redundancy of backup copies etc).

So you could (for example), run RMAN with:

backup archivelog all not backed up 2 times ;
delete archivelog all backed up 2 times to disk;

and do that every hour, or 3 hours, or whatever interval suits you best.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.