All entries for Tuesday 23 November 2004

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.

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!

Search this blog

Search Warwick Blogs

 

Tags

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
© MMXXII