VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Examples of Using the Command Line Interface Prerelease 8 September 2005, 8:55am
444 VERITAS Storage Foundation for Oracle Administrator’s Guide
Performing Storage Rollback Using dbed_ckptrollback
You can use the VERITAS Storage Foundation for Oracle dbed_ckptrollback command to
rollback an Oracle database to a Storage Checkpoint.
Prerequisites
◆ You may be logged in as either the database administrator or root.
Usage Notes
◆ The dbed_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 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 ru n t he dbed_update command after upgrading to VERITAS Storage Foundation
4.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.
▼ To roll back an Oracle database to a Storage Checkpoint
Use the dbed_ckptrollback command 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
Note 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.
Note In the case of an instant Storage Checkpoint, rolling back a tablespace does not apply.