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
371
Showing the Backup Control File List
This operation displays the list of control files that VxDBA has backed up each time you create a
Storage Checkpoint using VxDBA.
Show Backup Control File List displays a screen similar to the following:
Following the location of the backup control file, Show Backup Control File List displays the
following information:
DB UP? Shows the status of the Oracle instance (Y for ONLINE or N for OFFLINE) when the
Storage Checkpoint was taken. When a Storage Checkpoint is created while the Oracle instance is
up, the control files, initialization file, and the log information are backed up at the same time.
However, if a Storage Checkpoint is created while the Oracle instance is down, the log information
will not be available. If this backed up information is removed from the Storage Checkpoint
directory, the status of the INIT&CNTL? field becomes N (for null).
CKPT? Shows whether the same Storage Checkpoint still exists across all file systems used by the
database (see the discussion of partial Storage Checkpoints in “Displaying Storage Checkpoints”
on page 351 for more information). When one or more of the file systems used by the database does
not contain the named Storage Checkpoint, the status of CKPT? becomes n (for null).
INIT& CNTL. Shows whether the Oracle instance initialization file and the backup control file
still exist in the Storage Checkpoint directory. If this backed up information is removed from the
Storage Checkpoint directory, the status of the INIT& CNTL? field becomes N (for null).
Note If you need to recover the database from structural changes, these backup control files may
be required to effect the recovery. Storage Rollback does not automatically determine
whether this is the case, as usage depends on the Oracle recovery that the administrator
----------------------------------------------------
VxDBA: Show Backup Control File List - PROD
----------------------------------------------------
DB INIT&
Backup Control File UP? CKPT? CNTL?
------------------------------------------------- -- ----- -----
/etc/vx/vxdba/PROD/c*dir/Checkpoint_903937870 Y Y N
/etc/vx/vxdba/PROD/c*dir/Checkpoint_901426272 Y N Y
Press <Return> to continue...