VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 13, Using the VxDBA Utility
Prerelease 8 September 2005, 8:55am Using VxDBA to Perform Administrative Operations
365
Rolling Back Datafiles to a Storage Checkpoint
This operation rolls back database files to a Storage Checkpoint. You can also use this operation to
roll back more than one tablespace. Specify the list of files for Storage Rollback in a list file, or
enter the list of files one by one. If the database is offline Roll Back Files to a Storage Checkpoint
displays a screen similar to the following:
--------------------------------------------------------
VxDBA: Roll Back Files to a Storage Checkpoint - PROD
--------------------------------------------------------
ORACLE_SID : PROD
ORACLE_HOME : /usr1/oracle
Database Status : ORA-01034: ORACLE not available
# File Systems : 1
# Tablespaces : 4
# Datafiles : 4
To roll back files to a Storage Checkpoint, enter the name of
a list file that contains the set of files for Storage Rollback or
press <Return> to enter a list of file names one by one.
Enter the list file name [<name>,<Return>,q,?] <Return>
Enter a list of file names for Storage Rollback. To end the
list, enter <Return>. <Return>
Enter file name [<name>,<Return>,q,?] /db01/PROD/tsidx
Enter file name [<name>,<Return>,q,?] <Return>
# File Name
--- -------------------------------------
1 /db01/PROD/tsidx
Do you want to roll back these files to a Storage Checkpoint?
[y,n,q,?] (default: n) y