Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008

Note: Some database changes made after a Storage Checkpoint was taken may

make it impossible to perform an incomplete recovery of the databases after

Storage Rollback of an online or offline Storage Checkpoint using the current

control files. For example, you cannot perform incomplete recovery of the database

to the point right before the control files have recorded the addition or removal

of datafiles. To provide recovery options, a backup copy of the control file for the

database is saved in a temporary location when Storage Checkpoint rollback is

performed. Use extreme caution when recovering your database using alternate

control files.

Suppose a user deletes a table by mistake right after 4:00 p.m., and you want to

recover the database to a state just before the mistake. You created a Storage

Checkpoint (Checkpoint_903937870) while the database was running at 11:00

a.m., and you have ARCHIVELOG mode enabled.

To recover the database using a Storage Checkpoint

Ensure that the affected datafiles, tablespaces, or database are offline, and

use Storage Rollback to roll back any datafiles in the database that contained

the table data from the Storage Checkpoint you created at 11:00 a.m.

$ /opt/VRTS/bin/dbed_ckptrollback -H /oracle/product/9i -S PROD \

-c Checkpoint_903937870

Start up the database instance if it is down.

Use recover database until cancel, recover database until change,

or recover database until time to re-apply archive logs to the point before

the table was deleted to recover the database to 4:00 p.m.

Open the database with alter database open resetlogs.

Delete the Storage Checkpoint you created at 11:00 a.m. and any other Storage

Checkpoints created before that time.

Create a new Storage Checkpoint.

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. However, you can clone on any host within an Oracle RAC database

cluster.

169Using Storage Checkpoints and Storage Rollback

Cloning the Oracle instance using dbed_clonedb