Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

stores all necessary database file information, log file information, the name of
the database, the timestamp of database creation, and synchronization
information, such as the Storage Checkpoint and log-sequence information needed
for recovery.
Rolling back the control file will result in an inconsistency between the physical
database structure and the control file.
Ensure 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 location of archive destinations.
Note: Refer to your Oracle documentation for information about querying archived
information.
For Storage Foundation for Oracle RAC, 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.
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.
Media recovery procedures
The following procedures are for performing either a complete or incomplete
media recovery.
Media recovery procedures
Using Database Storage Checkpoints and Storage Rollback
Guidelines for Oracle recovery
208