Backup archive

Today i found one datafile offine. When i tried to bring it online and do media recovery, it require archivelogs dated backup to august, which is 3 months ago.

Once the RMAN backup database, it deletes log file to save disk space. So the lives of these archivelogs are only 1 day. You can only access old file legato disk backup only if the file's life is longer than one month.

Solution:

1. Do not use rman deletion. then another script has to do rman check archivelog redundancy ( can it be done?) and deletion monthly


2. Do not delete rman archive backup set. Then rman check archivelog backupset redundancy and delete it montnly


3. copy archivelog to a backup directory and deleted it use existing oldfile-cycle.sh. Do not need change any existing script. I use this one!

Hongfeng Sun : 23 Nov 2004 16:38 |  Tags: Oracle |  Comments (0) |  Report a problem