Veritas Storage Foundation 5.0 for Oracle RAC Configuration Guide Extracts for HP Serviceguard Storage Management Suite, Second Edition, May 2008

Using Storage Checkpoints and Storage Rollback
Examples of Using the Command Line Interface
Chapter 4
61
To unmount Storage Checkpoints
•Use the dbed_ckptumount command as follows:
$ /opt/VRTS/bin/dbed_ckptumount -S PROD \
-c Checkpoint_971672042_wr001
Performing Storage Rollback Using dbed_ckptrollback
You can use the dbed_ckptrollback command to rollback an Oracle database to a
Storage Checkpoint.
Before performing a Storage Rollback, the following conditions must be met:
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/10g -c Checkpoint_903937870
To rollback a tablespace to a Storage Checkpoint
•Use the dbed_ckptrollback command with the -T option as follows:
Usage notes The dbed_ckptumount command is used to unmount a mounted
Storage Checkpoint from the file system namespace. Mounted
Storage Checkpoints appear as any other file system on the machine
and can be accessed using all normal file system based commands.
When mounted Storage Checkpoints are not required, they can be
unmounted.
See the dbed_ckptumount(1M) manual page for more information.
Table 4-9 Unmounting Storage Checkpoints Notes (Continued)
Table 4-10 Perform Storage Rollback Notes
Prerequisites You may be logged in as either the database administrator or
superuser.
Usage notes 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 HP
Storage Management suite for Oracle RAC 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.