All entries for Tuesday 23 November 2004
November 23, 2004
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.
- Do not use rman deletion. then another script has to do rman check archivelog redundancy ( can it be done?) and deletion monthly
- Do not delete rman archive backup set. Then rman check archivelog backupset redundancy and delete it montnly
- 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!