dbed_ckptdisplay - display Storage Checkpoints for an Oracle database

DESCRIPTION

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.

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

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 I <ORACLE_SID>. The SFDB repository does not contain Storage Checkpoint information.

UN

Indicates that the Storage Checkpoint type is Unknown.

OPTIONS

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 I<ORACLE_HOME> setting for the I<ORACLE_SID> database.

-c <CKPT_NAME>

Specifies a specific Storage Checkpoint to display.

-o <dbed> | B<other> | B<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.

EXAMPLES

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

NOTES

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.