Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Use SET UNTIL SCN to prevent recovery of the online logs

516567Jun 5 2006 — edited Oct 11 2006
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2006
Added on Jun 5 2006
4 comments
18,459 views