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
363
▼
If the database is online
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 : ONLINE
# File Systems : 1
# Tablespaces : 4
# Datafiles : 4
WARNING: Oracle instance
PROD is still running.
Proceed with ONLINE rollback? [y,n,q,?] (default: n) y
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