Question on steps after restoring database using recover until time?
844914Mar 4 2011 — edited Mar 5 2011As part of SOX Compliance, I was requested to restore an Oracle 10g database in archive log mode to another system and apply archive logs to a date and time to prove tape backups and restoration works.
So I cloned the system and oracle started fine, so I removed all the database files and restored the database files.
Now I am ready to start the post processing but I am unsure on the exact steps to recover the database until time. I know I will only get one shot at it and really do not want to wait 8 hours for the tapes to restore in the event I make a mistake with the recovery.
With the database files restored, so far I have the following steps for post processing:
STARTUP MOUNT;
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL TIME '2011-03-03 21.03.24'; (With the time being the end of the online backup from last night)
copy archive files to archive directory
AUTO - apply archive logs until I get the message (media recovery complete!)
ALTER DATABASE OPEN resetlogs;
SHUTDOWN;
EXIT;
Am I on the right track?
Any input would be greatly appreciated!
Thank you!