VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Using VxDBA to Perform Administrative Operations Prerelease 8 September 2005, 8:55am
358 VERITAS Storage Foundation for Oracle Administrator’s Guide
Storage Checkpoints can only be used to roll back files that are damaged due to a software error or
a human error (for example, accidental deletion of a table). Because Storage Checkpoints reside on
the same physical disks as the primary file system, when a file is corrupted due to a media failure,
the file on the Storage Checkpoints will not be available either. In this case, you need to restore files
from a tape backup.
Note Some database changes, made after a Storage Checkpoint was taken, will make it impossible
to run Storage Rollback successfully. For example, you cannot successfully run Storage
Rollback if the control files for the database have recorded the addition or removal of
datafiles To provide recovery options, a backup copy of the control file for the database is
saved under the /etc/vx/vxdba/$ORACLE_SID/checkpoint_dir/CKPT_NAME
directory just after a Storage Checkpoint is created. You can use this file to assist with
database recovery, if necessary. If possible, both an ascii and binary version of the control
file will be left under the
/etc/vx/vxdba/$ORACLE_SID/checkpoint_dir/CKPT_NAME directory, with
the binary version being compressed to conserve space. Use extreme caution when
recovering your database using alternate control files.
After the files are rolled back, you may need to follow the recovery procedure described in the
Oracle manuals to recover the database before the database can be used.
Rolling Back the Database to a Storage Checkpoint
This operation rolls back the entire database (all the datafiles used by the database, except the redo
logs and control files) to a Storage Checkpoint. You must shut down the database to roll back the
database.
Note While the Storage Rollback process is running, it creates a temporary file,
/filesystem/.VRTSstrb.lock, in each file system. Do not remove these temporary
lock files.