VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Appendix A, VERITAS Storage Foundation for Oracle Command Line Interface
Prerelease 8 September 2005, 8:55am Examples of Using the Command Line Interface
433
Displaying Storage Checkpoints Using dbed_ckptdisplay
You can use the VERITAS Storage Foundation for Oracle dbed_ckptdisplay command to
display the Storage Checkpoints associated with an Oracle database from the command line. You
can also use it to display fileset quota values.
Prerequisites
You may be logged in as either the database administrator or root.
Usage Notes
In addition to displaying the Storage Checkpoints created by VxDBA, dbed_ckptdisplay
also displays other Storage Checkpoints (for example, Storage Checkpoints created by the
Capacity Planning Utility and NetBackup).
See the dbed_ckptdisplay(1M) manual page for more information.
The Status field identifies if the Storage Checkpoint is partial (P), complete (C), invalid (I),
mounted (M), read-only (R), writable (W), or of type online (ON), offline (OF), instant (IN), or
unknown (UN).
Database FlashSnap commands are integrated with Storage Checkpoint functionality. It is
possible to display and mount Storage Checkpoints carried over with snapshot volumes to a
secondary host. However limitations apply. For details, see “Mounting the Snapshot Volumes
and Backing Up” on page 241.
To display Storage Checkpoints created by VERITAS Storage Foundation for Oracle
Use the dbed_ckptdisplay command as follows to display information for Storage
Checkpoints created by VERITAS Storage Foundation for Oracle:
$ /opt/VRTS/bin/dbed_ckptdisplay -S PROD \
-H /oracle/product/9i
Checkpoint_975876659 Sun Apr 3 12:50:59 2004 P+R+IN
Checkpoint_974424522_wr001 Thu May 16 17:28:42 2004 C+R+ON
Checkpoint_974424522 Thu May 16 17:28:42 2004 P+R+ON
To display other Storage Checkpoints
Use the dbed_ckptdisplay command as follows:
$ /opt/VRTS/bin/dbed_ckptdisplay -S PROD \
-H /oracle/product/9i -o other
NetBackup_incr_PROD_955133480 NBU /db01
NetBackup_full_PROD_955132952 NBU /db01