dbed_ckptdisplay - display Storage Checkpoints for an Oracle database

dbed_ckptdisplay -S ORACLE_SID [ -H ORACLE_HOME ]
[ -c CKPT_NAME ] [ -o dbed | other | all ]
[ -Q ] [ -n ] [ -h ]

Veritas Storage Foundation. To determine whether this product is installed on the system, enter:

 rpm -qa | grep VRTSdbed

The dbed_ckptdisplay command displays Storage Checkpoints associated with the current Oracle instance. One or all Storage Checkpoints may be displayed, depending on whether the -c option is used.

Storage Checkpoint information is displayed with the following columns of output:

 Storage Checkpoint Creation Time Status
 --------------------------- ------------------------ -------
 Checkpoint_975876659 Sun Dec 3 12:50:59 2003 P+R+IN
 Checkpoint_974424522_wr002 Thu Nov 16 17:28:42 2003 C+W+ON
 Checkpoint_974424522_wr001 Thu Nov 16 17:28:42 2003 C+W+ON
 Checkpoint_974424522 Thu Nov 16 17:28:42 2003 C+W+M+ON

The Status column of dbed_ckptdisplay output can contain the following values:

C	Indicates that the Storage Checkpoint is complete. That is, every file system that the Oracle database resides on contains the Storage Checkpoint.
P	Indicates that the Storage Checkpoint is partial. That is, some file systems on which the Oracle database resides do not contain the Storage Checkpoint. This can occur in three different circumstances: (1) When a file system runs out of space, one or more of the Storage Checkpoint components can be removed. See the dbed_ckptremove command for more information. (2) When the Oracle database changes shape (that is, has tablespaces and datafiles added or deleted), more file systems may be added to the configuration. Since these file systems were not present when the Storage Checkpoint was created, the Storage Checkpoint appears to be only a partial image of the Oracle database. (3) Storage Checkpoint elements can be removed at any time by a database administrator.
R	Indicates that the Storage Checkpoint is read only. It has not been modified and therefore is a consistent point-in-time image of the Oracle database and file systems.
W	Indicates that the Storage Checkpoint is writable. It has been mounted read/write and potentially modified. Modified Storage Checkpoints are not valid for Storage Rollback operations, since the data is in an unknown state.
M	Indicates that the Storage Checkpoint is mounted. If it is Read Only, it can be used with either the dbed_ckptrollback or dbed_clonedb commands. A mounted Storage Checkpoint can also be used for online backup of the Oracle database or investigation using Oracle tools such as dbv.
ON	Indicates that the Storage Checkpoint type is Online.
OF	Indicates that the Storage Checkpoint type is Offline.
IN	Indicates that the Storage Checkpoint type is Instant.
I	Invalid for current ORACLE_SID. The SFDB repository does not contain Storage Checkpoint information.
UN	Indicates that the Storage Checkpoint type is Unknown.

The following options are supported:

-S ORACLE_SID	Specifies the name of the Oracle database for which Storage Checkpoints will be displayed.
-H ORACLE_HOME	Specifies the ORACLE_HOME setting for the ORACLE_SID database.
-c CKPT_NAME	Specifies a specific Storage Checkpoint to display.
-o dbed | other | all	Specifies which Storage Checkpoints to display. The default is to display only Storage Checkpoints created by Veritas Storage Foundation for Oracle. The display format of the other types of Storage Checkpoints is different from the output of Storage Checkpoints created by Veritas Storage Foundation for Oracle.
-Q	This option has no effect. It is retained for backwards compatibility.
-n	This option has no effect. It is retained for backwards compatibility.
-h	Shows command usage.

This example shows the Storage Checkpoint information that is displayed for the Oracle database, PROD:

 $ /opt/VRTS/bin/dbed_ckptdisplay -S PROD -H /ora_base/db_home
 Storage Checkpoint Creation time Status
 ==============================================================================
 Ckpt_1313572750 Wed Aug 17 14:16:59 2011 C+R+ON
 Ckpt_1313575000 Wed Aug 17 14:17:11 2011 C+R+IN
 Ckpt_1313572750_rw_1313571263 Wed Aug 17 14:17:55 2011 C+W+M+ON

dbed_ckptdisplay can be run as either the Oracle DBA or the superuser.

If neither the -c nor the -o options are supplied, then all Storage Checkpoints created by dbed_ckptcreate are displayed.

If both the -c and the -o options are supplied, then the -o option will overwrite the -c option. All the checkpoints with the specified type will be displayed.

dbed_ckptdisplay(1M), dbed_ckptmount(1M), dbed_ckptremove(1M), dbed_ckptrollback(1M), dbed_ckptumount(1M), dbed_clonedb(1M), dbed_update(1M), vxsfadm-oracle-checkpoint(1M), vxsfadm(1M)

Veritas Storage Foundation: Storage and Availability Management for Oracle Databases Guide

Veritas Storage Foundation for Oracle RAC Installation and Configuration Guide