Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

■ This command is supported by Veritas Storage Foundation for
Oracle RAC.
■ The dbed_ckptrollback command 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 the database
be inactive before Storage Rollback commences. The
dbed_ckptrollback command will not commence if the Oracle
database 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).
■ You must run the dbed_update command after upgrading to
Veritas Storage Foundation Product version: 5.0.1 for Oracle from
a previous release. This will allow you to roll back to a Storage
Checkpoint that was created with an earlier version of this product.
■ See the dbed_ckptrollback(1M) manual page for more
information.
Usage notes
To roll back an Oracle database to a Storage Checkpoint
◆
Use the dbed_ckptrollbackcommand as follows:
$ /opt/VRTS/bin/dbed_ckptrollback -S PROD -H \
/oracle/product/9i -c Checkpoint_903937870
To rollback a tablespace to a Storage Checkpoint
◆
Use the dbed_ckptrollback command with the -T option as follows:
$ /opt/VRTS/bin/dbed_ckptrollback -S PROD -H \
/oracle/product/9i -T DATA01 -c Checkpoint_903937870
If the Oracle database is running, you must take the tablespace offline before
running this command. If the tablespace is online, the command will fail.
In the case of an instant Storage Checkpoint, rolling back a tablespace does
not apply.
341Veritas Storage Foundation for Oracle Command Line Interface
About the command line interface