Hi,
I had a couple of prior notes in this forum and thanks for the help so far. I'm new at using RMAN.
.
As mentioned in a previous note, we do a Cold backup every night on disk, once done we copy it to tape and prior to the next backup we remove the backup and do a CROSSCHECK BACKUP and DELETE EXPIRED ..
.
I did some tests and restoring the latest Backupset and applying the current arc filesand redo logs and it worked fine.
But what if the current Backupset is corrupt and we need to restore from a previous Backupset, then apply the Arc Backupset and then the current Arc and redo files ?
.
To test this I tried this moving the previous Backupset (which was on tape) to the current backup disk directory, found the TAG number from the previous backup logs, then tried to do a RESTORE DATABASE FROM TAG='xxxxxxx' but it failed with RMAN-06023: no backup or copy of datafile X found to restore.
.
When I do a LIST BACKUP; , I only see the latest Backupset tag and not any of the previous tags which I assume was deleted by the DELETE EXPIRED.
.
Also If I restore the previous ControlFile , then I assume I will be able to restore the previous backupset but will probably not be able to recover until the latest redo logs;
.
So what is the proper procedure to Restore from a Previous backupset , then apply the Arc backupset, then the current arc files and redo logs ?
.
I'm sure this procedure is documented somewhere but I coudl not find it.
Thanks again