RMAN & Archivelog Deletion Policy confusion

oracleoracle-11g-r2

Never been able to fully grasp the notion of delete input/delete input all when backup up Archivelog with rman.

Tied to the same issue is the configure Archivelog deletion policy to backed up X times to disk.

Deleting input, or deleting input all, seems counterintuitive to me when the deletion policy is set to 7 times to match an overall backup policy of 7 days.

Is there anyone here who can explain to someone who may be just a little dense how this all plays together? And what should the Archivelog deletion policy be if the goal is to have one week’s worth of backups available at all times? All backups are weekly backed up to a tape drive. With seven days as overall, and 7 times on Archivelog deletions policy, am I backing it up 7 times or 7 times 7 times?

Thank you for any help anyone can offer……

Best Answer

Am a bit confused about what exactly is your question(s). Let me see if I can answer (at least) some part:

Never been able to fully grasp the notion of delete input/delete input all when backup up Archivelog with rman.

I believe you are talking about DELETE INPUT part of the syntax of BACKUP command. This part tells oracle to delete the archived logs that exist at the time BACKUP command is run (as well as those generated during the execution of BACKUP command) ONLY AFTER BACKUP has successfully backed up the archived logs. Without this part, the archived logs are not deleted.

Deleting input, or deleting input all, seems counterintuitive to me when the deletion policy is set to 7 times to match an overall backup policy of 7 days.

A deletion policy is used by Oracle to manage the space in flash recovery area. Oracle can delete archived logs in flash recovery area when the flash recovery area is full and there exist archived logs that satisfy deletion policy criteria i.e. if deletion policy criteria is set to 2 days and the flash recovery area gets full, say, on Thursday then oracle will automatically delete archived logs older than 2 days (i.e. before Wednesday) to free up the space.

And what should the Archivelog deletion policy be if the goal is to have one week’s worth of backups available at all times?

That depends upon a) How much data loss is the business/company is prepared to tolerate? & b) What is the SLA (Service Level Agreement) time for recovery of database & c) your backup strategy (hot/cold, full/incremental, image copy/backupset etc.)

Hope this helps.

Related Question