Use SET UNTIL SCN to prevent recovery of the online logs
516567Jun 5 2006 — edited Oct 11 2006I am using RMAN to make daily full backups of my database. I have been practicing a disaster recovery scenario where all that is available is the backup tapes stored off-site. I am using the autobackup feature to restore the PFILE and the CONTROL file. I understand this will be incomplete recovery (I will lose any data that was entered since the completion of the backup).
I am following an example I found in the documentation for disaster recovery to a new host. It has the following just before the RESTORE DATABASE command:
# Do a SET UNTIL to prevent recovery of the online logs
SET UNTIL SCN 1234567;
I used the following to get this SCN number from the control file I had just restored:
select max(next_change#)-1 from v$archived_log;
Is this the correct value for me to use? Also, is it necessary for me to use the SET UNTIL SCN? I want to restore everything that is available from the backup and then open the database (which I have been using ALTER DATABASE OPEN RESETLOGS;)
This is the process that I have been following and the restore/recover appears to be working great.... I just want to verify with someone that I am using the correct SCN number and if there is a better way to accomplish my objective.
Thanks,
Rob