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
357
Note When you remove Storage Checkpoints created by NetBackup, remember to restart the
backup schedule. Also remember that NetBackup needs two Storage Checkpoints to perform
an incremental backup. If you remove Storage Checkpoints needed for incremental backups,
NetBackup will perform a full backup instead of an incremental backup.
Managing Storage Rollback
Use the Storage Rollback Administration menu to roll back a database file, a list of database
files, a single tablespace, or the entire database to a Storage Checkpoint.
Note You must be the Oracle Database Administrator to perform Storage Rollback operations.
You must shut down the instance to perform full Storage Rollback of the database, or you
can elect to leave the database up to roll back a file or tablespace. In this situation, VxDBA
checks to see if the target database objects are offline before proceeding. See “Using Storage
Checkpoints and Storage Rollback for Backup and Restore” on page 163 and “Guidelines
for Oracle Recovery” on page 181 for more information.
This operation displays a screen similar to the following:
VERITAS Storage Foundation for Oracle (ORACLE_SID 'PROD')
Menu: Storage Rollback Administration
Database Status : OFFLINE
# File Systems : 1
# Tablespaces : 4
# Datafiles : 4
1 Roll Back the Database to a Storage Checkpoint
2 Roll Back a Tablespace to a Storage Checkpoint
3 Roll Back Files to a Storage Checkpoint
4 Set Number of Storage Rollback Threads
5 Set Buffer Size for Storage Rollback
6 Show Backup Control File List
? Display Help About the Current Menu
q Exit From Current Menu
x Exit From VxDBA Utility
Select Operation to Perform: