VERITAS Storage Foundation 4.1 for Oracle RAC HP Serviceguard Storage Management Suite Extracts, December 2005

Examples of Using the Command Line Interface
Performing Storage Rollback Using sfrac_ckptrollback
You can use the VERITAS Storage Foundation for RAC sfrac_ckptrollback
command to roll back an Oracle instance to a Storage Checkpoint.
Usage Notes
The sfrac_ckptrollback rolls an Oracle database back to a specified Storage
Checkpoint. You can perform a storage rollback for the entire database, a specific
tablespace, or list of datafiles.
Database rollback for the entire database requires that all database instances be
stopped before storage rollback commences. The sfrac_ckptrollback command
does not commence if any Oracle database instance is active. However, to perform a
storage rollback of a tablespace or datafile, only the tablespace or datafile to be rolled
back must be offline (not the entire database).
Use the sfrac_ckptumount command to unmount a checkpoint mounted as
read-only before using that checkpoint with the sfrac_ckptrollback command.
See the sfrac_ckptrollback(1M) manual page for more information.
To roll back an offline Oracle instance to a Storage Checkpoint
Use the sfrac_ckptrollback command as in the following example:
$ /opt/VRTS/bin/sfrac_ckptrollback -S DB12 -H $ORACLE_HOME \
-c Checkpoint_903937870
To roll back a tablespace to a Storage Checkpoint
Use the sfrac_ckptrollback command with the -T option as in the following
example:
$ /opt/VRTS/bin/sfrac_ckptrollback -S DB12 -H $ORACLE_HOME \
-T
DATA01
-c Checkpoint_903937870
Note If the Oracle instance is running, you must take the tablespace offline before
running this command. If the tablespace is online, the command will fail.
150 VERITAS Storage Foundation for Oracle RAC Installation and Configuration Guide