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 run the 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:

  To rollback a tablespace to a Storage Checkpoint

Use the dbed_ckptrollback command with the -T option as follows:

  To rollback datafiles to a Storage Checkpoint

Use the dbed_ckptrollback command with the -F option as follows: