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
361
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 tablespace to a Storage Checkpoint.
Note 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. See “Cloning the Oracle Instance Using dbed_clonedb” on page 449
for more information.
▼ If the database is offline
Roll Back a Tablespace to a Storage Checkpoint displays a screen similar to the following:
---------------------------------------------------------------
VxDBA: Roll Back a Tablespace 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
Select a tablespace:
Tablespace Name File Name
--------------------------------- ------------------------
SYSTEM /db01/PROD/sys1
TSTAB /db01/PROD/tstab
TSIDX /db01/PROD/tsidx
TSTMP /db01/PROD/tstmp
Enter a tablespace name [<name>,q,?] TSIDX
TABLESPACE: TSIDX
# File Name
--- -------------------------------------
1 /db01/PROD/tsidx
Do you want to roll back the files used by TSIDX to a Storage
Checkpoint? [y,n,q,?] (default: n) y