Veritas Storage Foundation for Oracle 5.0 Graphical User Interface Guide, HP-UX 11i v3, First Edition, May 2008

While the Storage Rollback process is running, it creates a temporary file,
/filesystem/.VRTSstrb.lock, in each file system. Do not remove these temporary
lock files.
To rollback the database to a Storage Checkpoint
1
Shut down the Oracle database from the GUI.
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
Access the Roll Back a Storage Checkpoint wizard.
See “Accessing Storage Checkpoint tasks in the Java GUI” on page 27.
See “Accessing database tasks in the Web GUI” on page 35.
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.
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.
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. (You cannot recover your database through the GUI.)
11
Restart the database from the GUI.
69Managing Storage Checkpoints
Rolling back to a Storage Checkpoint