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

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, a confirmation message displays. Click
OK to continue.
11
Click Yes to rollback the datafile or datafiles. Perform any necessary Oracle
media recovery. (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.
■ You can perform this operation while the database is online as
long as the tablespace is offline.
Prerequisites
To roll back datafiles to a Storage Checkpoint
1
Verify that the datafile to which you want to roll back is offline.
2
Access the Rollback 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.
3
If the database is online, you will receive a prompt asking you if you want to
continue. Click Yes to continue the Storage Rollback.
4
In the Rollback a Storage Checkpoint wizard, 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.
71Managing Storage Checkpoints
Rolling back to a Storage Checkpoint