November 23, 2004

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.


  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 Do not need change any existing script. I use this one!

- No comments Not publicly viewable

Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

Search Warwick Blogs



Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder