Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

To rollback datafiles to a Storage Checkpoint
◆
Use the dbed_ckptrollback command with the -F option as follows:
$ /opt/VRTS/bin/dbed_ckptrollback -S PROD \
-H /oracle/product/ORA_HOME \
-F /share/oradata1/data01.dbf,/share/oradata2/index01.dbf \
-c Checkpoint_903937870
If the Oracle database is running, you must take the datafile offline before
running this command. If the datafile is online, the command will fail.
In the case of an instant Storage Checkpoint, rolling back datafiles does not
apply.
Removing Storage Checkpoints using dbed_ckptremove
You can use the dbed_ckptremove command to remove a Storage Checkpoint for
an Oracle database at the command line.
Before removing Storage Checkpoints, the following conditions must be met:
■ You must be logged on as the database administrator.Prerequisites
■ The dbed_ckptremove command is used to remove a Storage
Checkpoint from the file system, or file systems, it is associated
with. The Storage Checkpoint must have been created using the
dbed_ckptcreate(1M) command.
■ You must unmount the Storage Checkpoint before you can remove
it.
■ See the dbed_ckptremove(1M) manual page for more information.
Usage notes
To remove Storage Checkpoints
◆
Use the dbed_ckptremove command as follows:
$ /opt/VRTS/bin/dbed_ckptremove -S PROD \
-c Checkpoint_971672042_wr001
Cloning the Oracle instance using dbed_clonedb
You can use the dbed_clonedb command to clone an Oracle instance using a
Storage Checkpoint.
221Using Database Storage Checkpoints and Storage Rollback
Database Storage Checkpoint Commands