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

$ /opt/VRTS/bin/dbed_ckptrollback -S PROD \

-H /oracle/product/10g -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.

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/10g -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 fails.

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:

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.

Cloning an existing database using a Storage Checkpoint must be done on the same

host.

You have the option to manually or automatically recover the database when using the

dbed_clonedb command:

Table 4-11 Remove Storage Checkpoints Notes

Prerequisites You may be logged in as either the database administrator or

superuser.

Usage notes 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.