Performing Storage Rollback Using sfrac_ckptrollback
You can use the VERITAS Storage Foundation for RAC sfrac_ckptrollback command to roll back an Oracle instance to a Storage Checkpoint.
Usage Notes
- The sfrac_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 all database instances be stopped before storage rollback commences. The sfrac_ckptrollback command does not commence if any Oracle database instance 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).
- Use the sfrac_ckptumount command to unmount a checkpoint mounted as read-only before using that checkpoint with the sfrac_ckptrollback command.
- See the sfrac_ckptrollback(1M) manual page for more information.
To roll back an offline Oracle instance to a Storage Checkpoint
Use the sfrac_ckptrollback command as in the following example:
$ /opt/VRTS/bin/sfrac_ckptrollback -S DB12 -H $ORACLE_HOME \
-c Checkpoint_903937870
To roll back a tablespace to a Storage Checkpoint
Use the sfrac_ckptrollback command with the -T option as in the following example:
$ /opt/VRTS/bin/sfrac_ckptrollback -S DB12 -H $ORACLE_HOME \
-T DATA01 -c Checkpoint_903937870
Note
If the Oracle instance is running, you must take the tablespace offline before running this command. If the tablespace is online, the command will fail.
To roll back datafiles to a Storage Checkpoint
Use the sfrac_ckptrollback command with the -F option as in the following example:
$ /opt/VRTS/bin/sfrac_ckptrollback -S DB12 -H $ORACLE_HOME \
-F /share/oradata1/data01.dbf,/share/oradata2/index01.dbf \
-c Checkpoint_903937870
Note
If the Oracle instance is running, you must take the datafile offline before running this command. If the datafile is online, the command will fail.
Removing Storage Checkpoints Using sfrac_ckptremove
You can use the VERITAS Storage Foundation for Oracle RAC sfrac_ckptremove command at the command line to remove a Storage Checkpoint for an Oracle database.
Usage Notes
- The sfrac_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 sfrac_ckptcreate(1M) command.
- See the sfrac_ckptremove(1M) manual page for more information.
- You must unmount the Storage Checkpoint before you can remove it.
To remove Storage Checkpoints
Use the sfrac_ckptremove command as follows:
$ /opt/VRTS/bin/sfrac_ckptremove-S DB12 \
-c Checkpoint_971672042_wr001
|
