Veritas Storage Foundation™ for Oracle 5.0.1 Graphical User Interface Guide
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.
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.
Rolling back a tablespace is used for complete recovery of the tablespace. It is not
designed for point-in-time (incomplete) tablespace recovery, which is more
complicated and requires interaction with Oracle Customer Support. The
tablespace point-in-time recovery requires using a clone database. For more
information:
See “Creating a clone database” on page 41.
■ You can perform this operation while the database is online as
long as the tablespace is offline.
Prerequisites
57Managing Storage Checkpoints
Rolling back to a Storage Checkpoint