Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

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 and detailed information on recovery.
Using the GUI to perform Storage Checkpoint-related
operations
You can use the GUI to create Storage Checkpoints and then roll back an entire
database, a single tablespace, or any set of datafiles using any of the previously
created Storage Checkpoints.
See the Veritas Storage Foundation for Oracle Graphical User Interface Guide.
Veritas Storage Foundation for Oracle RAC does not support the GUI.
Using Storage Checkpoints and Storage Rollback
Using the GUI to perform Storage Checkpoint-related operations
176