VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Managing Storage Checkpoints Prerelease 8 September 2005, 8:55am
300 VERITAS Storage Foundation for Oracle Administrator’s Guide
The Rollback a Storage Checkpoint wizard is displayed.
4. Verify that you are rolling back to the correct Storage Checkpoint and click Next to continue.
If you selected the wrong Storage Checkpoint, click Cancel. The information on this screen is
read-only.
5. On the second screen, use the drop-down menu to select the appropriate buffer size in the
Rollback Buffer Size field. The default buffer size is 128K.
Note The buffer size configured for reads and writes when performing a Storage Rollback can
affect performance. Vary the size to determine the optimal setting for your system.
6. Use the drop-down menu to select the appropriate number of threads in the Number of Threads
field. The default number of threads is four.
Note Depending on the number of CPUs available on your system and the type of volume on
which the file system is located, this default setting may specify too few or too many
threads.
7. Click the Roll back a database button to indicate that you are rolling back the entire database
to the Storage Checkpoint.
8. Click Next to continue. Click Roll Back to continue.
If the Storage Rollback was successful, a confirmation message is displayed.
9. To see the Storage Rollback details, click the Show details checkbox. The details are displayed
in the pop-up window.
When you have finished viewing the details, click OK.
10. Click Yes to roll back the tablespace or tablespaces. Perform any necessary Oracle recovery.
See “Guidelines for Oracle Recovery” on page 181 for more information. (You cannot recover
your database through the GUI.)
11. Restart the database from the GUI.
Rolling Back a Tablespace to a Storage Checkpoint
If a tablespace is corrupted or removed due to a software error or a human mistake, this operation
rolls back all of the files of the corrupted or removed tablespace to a Storage Checkpoint.
This option is only available for offline and online Storage Checkpoints. You cannot roll back a
tablespace to an instant Storage Checkpoint.