VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Guidelines for Oracle Recovery Prerelease 8 September 2005, 8:55am
182 VERITAS Storage Foundation for Oracle Administrator’s Guide
Note After rolling back the database (including control files and redo logs) to a Storage
Checkpoint, you need to recover the Oracle database instance. Rolling the database forward
is not supported; that is, you cannot apply archived redo logs.
◆ To perform a complete media recovery:
SET AUTORECOVERY ON;
RECOVER DATABASE;
◆ To perform an incomplete media recovery, use one of the following:
◆ RECOVER DATABASE UNTIL CANCEL;
◆ RECOVER DATABASE UNTIL TIME ’yyyy-mm-dd:hh:mm:ss’;
(You can confirm the time of error by checking the
$ORACLE_HOME/rdbms/log/alert*.log file.)
◆ RECOVER DATABASE UNTIL TIME ’yyyy-mm-dd:hh:mm:ss’ using \
backup controlfile;
◆ RECOVER DATABASE UNTIL CHANGE scn;
◆ To open the database after an incomplete media recovery, use the following:
◆ ALTER DATABASE OPEN RESETLOGS;
RESETLOGS resets the log sequence. The RESETLOGS option is required after an
incomplete media recovery. After opening the database with the RESETLOGS option,
remove the Storage Checkpoint you just rolled back to as well as any Storage
Checkpoints that were taken before that one. These earlier Storage Checkpoints can
no longer be used for Storage Rollback. After removing these Storage Checkpoints,
be sure to create a new Storage Checkpoint.
Caution Attempting to roll back to the same Storage Checkpoint more than once can result in
data corruption. After rolling back, be sure to delete the Storage Checkpoint that you
rolled back to and then create a new one.
See your Oracle documentation for complete information on recovery.