VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Using VxDBA to Perform Administrative Operations Prerelease 8 September 2005, 8:55am
368 VERITAS Storage Foundation for Oracle Administrator’s Guide
After you select a Storage Checkpoint, VxDBA rolls back the files to the selected Storage
Checkpoint in parallel. Parallel Storage Rollback significantly reduces the time required to roll
back files. When all the files are rolled back, follow the Oracle recovery procedure to recover the
database before the database is used.
Enter a Storage Checkpoint number [<number>,q,?] 1
The following information may be required for Oracle
recovery procedures. Times reflect the real begin and
end times for Oracle tablespaces being in hot-backup
mode.
Begin hot backup time: Fri May 13 22:51:10 PDT 2003
End hot backup time : Fri May 13 22:51:15 PDT 2003
Do you want to roll back files to
Fri May 13 22:51:10 2003? [y,n,q,?] (default: n) y
From the following list, select the Storage Checkpoint to roll back
the files to.
NOTICE: Datafile/db01/PROD/tsidx is currently online
and must be taken offline for online rollback.
Do you want to offline datafile (s) for rollback? [y,n,q,?]
(default: y) y
Running script to offline datafile (s).
Rolling back files to Checkpoint_903937870...
The files have been rolled back to a Storage Checkpoint dated
Fri May 13 22:51:10 2003.
You must follow the recovery procedure described in the
Oracle documentation before you can use the database.
Press <Return> to continue...