VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Using VxDBA to Perform Administrative Operations Prerelease 8 September 2005, 8:55am
362 VERITAS Storage Foundation for Oracle Administrator’s Guide
VxDBA prompts you for a tablespace name, and then displays a list of Storage Checkpoints:
After you select a Storage Checkpoint, VxDBA rolls back the files of the selected tablespace in
parallel. Parallel Storage Rollback significantly reduces the time required to roll back a
tablespace.
From the following list, select the Storage Checkpoint, used
by the tablespace, to roll back the files to. Use the ’Roll
Back Files to a Storage Checkpoint’ option if you only plan to
roll back a single file or a set of files.
# Storage Checkpoint Creation Time Status
-- ------------------------------ -------------------------- ------
1 Checkpoint_903937870 Fri May 13 22:51:10 2003 C+R+ON
2 Checkpoint_901426272 Wed May 11 16:17:52 2003 P+R+I
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 tablespace TSIDX to
Fri May 13 22:51:10 2003? [y,n,q,?] (default: n) y
Rolling back tablespace TSIDX using Checkpoint_903937870...
The tablespace TSIDX has been rolled back to
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...