Performing Storage Rollback using dbed_ckptrollback
Prev Appendix B. Storage Foundation for Databases (SFDB) tools command line interface Next

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:

Prerequisites

  • You must be logged on as the database administrator (typically, the user ID oracle.)

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 Veritas Storage Foundation Product version: 5.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

To rollback a tablespace to a Storage Checkpoint

To rollback datafiles to a Storage Checkpoint

Prev Up Next
Administering Storage Checkpoint quotas using dbed_ckptquota Home Removing Storage Checkpoints using dbed_ckptremove