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