VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 12, Using the VERITAS Storage Foundation for Oracle Graphical User Interface
Prerelease 8 September 2005, 8:55am Managing Storage Checkpoints
303
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 Datafile button to indicate that you are rolling back the datafile to the
Storage Checkpoint.
8. Click Next to continue.
9. Select the datafile, or datafiles, you would like to roll back by clicking on the appropriate
checkbox in the Datafile list.
10. Click Roll Back to continue.
11. If the Storage Rollback was successful, you will receive a confirmation message. Click OK to
continue. You are then returned to the rollback window.
12. Perform any necessary Oracle media recovery. See “Guidelines for Oracle Recovery” on
page 181 for more information.
13. Put the recovered datafile back online.
Using a Storage Checkpoint Policy for Space Management
A Storage Checkpoint policy establishes how many Storage Checkpoints you would like to keep in
the event your file system becomes full. You can also determine what to do with old Storage
Checkpoints when you run out of space. You should set up a Storage Checkpoint policy before
creating any Storage Checkpoint schedules.