RMAN Gurus,
I have an RMAN script running crosscheck expired backupset; and delete noprompt expired backupset; It has been running for days now. It seems like the previous person who handled the backups forgot to run crosscheck and delete all expired backupset. There are over 32,000 plus expired backups that need to be deleted from the sbt tape.
I am executing my RMAN thru ssh (putty). We are using AVAMAR backup to tape.
Questions:
1. Is there a way to speedup the process? It has been running for days now.
2. What is the difference between OBSOLETE and EXPIRED backupset?
3. If my RMAN is executing thru ssh (using putty) from my laptop and abruptly disconnected my ssh connection because it rebooted, what will happen to my backupset that has been deleted for the past few days? Are they now permanently deleted from the catalog? or will they rollback after an abrupt disconnection? If I reconnect thru ssh to my database server and connect to RMAN again, do I need to re-execute crosscheck again?
4. if I execute the following:
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 days;
RMAN> crosscheck backupset; and then delete noprompt expired backupset;
will this also delete all obsolete backups? or Do I need to execute delete noprompt obsolete; separately?
5. What is the correct sequence of deleting backups?
a. delete expired backupset first or
b. delete obsolete first then proceed with deleting expired backups? or
c. it does not matter which comes first
These are not test questions, I am fairly new to RMAN and need your expert opinions on this.
More power to you all!
Thanks,
Johnnie