VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Managing Storage Checkpoints Prerelease 8 September 2005, 8:55am
302 VERITAS Storage Foundation for Oracle Administrator’s Guide
7. Click the Rollback a Tablespace button to indicate that you are rolling back the tablespace to
the Storage Checkpoint.
8. Click Next to continue. Select the tablespace, or tablespaces, you would like to roll back by
clicking the appropriate checkbox in the Tablespace list.
9. Click Roll Back to continue.
10. If the Storage Rollback was successful, you will receive a confirmation message. Click OK to
continue.
11. Click Yes to rollback the datafile or datafiles. Perform any necessary Oracle media recovery.
See “Guidelines for Oracle Recovery” on page 181 for more information. (You cannot recover
database information through the GUI.)
12. Put the recovered tablespace back online.
Rolling Back Datafiles to a Storage Checkpoint
Rolling back datafiles rolls back database files to a Storage Checkpoint. You can also use this
operation to roll back more than one datafile.
This option is only available for offline and online Storage Checkpoints. You cannot roll back a
datafile to an instant Storage Checkpoint.
Note You can perform this operation while the tablespace is online as long as the datafile is
offline.
▼ To roll back datafiles to a Storage Checkpoint
1. Verify that the datafile to which you want to roll back is offline.
2. Click the a specific Storage Checkpoint in the object tree. (You may need to expand the tree
view to find the Storage Checkpoint.)
3. Select one of the following methods to rollback to the selected Storage Checkpoint.
◆ From the menu bar, select Storage Checkpoint > Rollback a Storage Checkpoint.
or
◆ Right click the Storage Checkpoint to which you want to rollback to bring up a pop-up
menu. Then click Rollback a Storage Checkpoint.
If the database is online, you will receive a prompt asking you if you want to continue. Click
Yes to continue the Storage Rollback.