Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

■ Back up all control files before Storage Rollback in case the subsequent Oracle
recovery is not successful. Oracle recommends that you keep at least two copies
of the control files for each Oracle database and that you store the copies on
different disks. It is also a good idea to back up the control files before and
after making structural changes to databases.
■ Make sure that the control files are not rolled back.
A control file is a small binary file that describes the structure of the database
and must be available to mount, open, and maintain the database. The control
file stores all necessary database files information, log file information, the
name of the database, and the timestamp of database creation, as well as
synchronization information such as Storage Checkpoint and log sequence
information that is needed for recovery. Rolling back the control file will result
in an inconsistency between the physical database structure and the control
file.
Note: If your intention is to roll back the database to recover from structural
changes that you do not want to maintain, you may indeed want to roll back
control files.
■ Make sure that all archived redo logs are available.
A database backup with online and archived logs is required for a complete
database recovery. Query V$ARCHIVED_LOG to list all the archived log
information and V$ARCHIVE_DEST to list the status of archive destinations.
In Veritas Storage Foundation for Oracle RAC configurations, the archive log
destination must be on a Veritas Cluster File System.
To restore the necessary archived redo log files, you can query V$LOG_HISTORY
to list all the archived redo log history or query V$RECOVERY_LOG to list only
the archived redo logs needed for recovery. The required archived redo log
files can be restored to the destination specified in the LOG_ARCHIVE_DEST
parameter or to an alternate location. If the archived redo logs were restored
to an alternate location, use the ALTER DATABASE RECOVER ... FROM statement
during media recovery.
■ After Storage Rollback, perform Oracle recovery, applying some or all of the
archived redo logs.
To perform a complete media recovery:
◆
SET AUTORECOVERY ON;
RECOVER DATABASE;
175Using Storage Checkpoints and Storage Rollback
Guidelines for Oracle recovery