Displaying Storage Checkpoints using dbed


Displaying Storage Checkpoints using dbed_ckptdisplay
Prev	Appendix B. Storage Foundation for Databases (SFDB) tools command line interface	Next

Displaying Storage Checkpoints using dbed_ckptdisplay

You can use the 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.

Before displaying Storage Checkpoints, the following conditions must be met:

Prerequisites

You may be logged in as either the database administrator or root. If you execute the command as root, use the -n option.

Usage Notes

In addition to displaying the Databse Checkpoints created by the SFDB tools, dbed_ckptdisplay also displays other Storage Checkpoints (for example, Storage Checkpoints created by NetBackup).
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.
See the dbed_ckptdisplay(1M) manual page for more information.

To display Database Checkpoints

Use the dbed_ckptdisplay command as follows to display information for Storage Checkpoints:

$ /opt/VRTS/bin/dbed_ckptdisplay -S PROD \
-H /oracle/product

Storage Checkpoint       				 Creation Time                 Status
Checkpoint_1239780697         Wed Apr 15 13:01:37 2009      C+R+ON

Checkpoint_974424522_wr001	   Thu May 16 17:28:42 2009			 		C+R+ON

To display other Storage Checkpoints

Use the dbed_ckptdisplay command as follows:

$ /opt/VRTS/bin/dbed_ckptdisplay -S PROD \
-H /oracle/product -o other

Storage Checkpoint                   Creator   Location
----------------------------------   -------   --------
NetBackup_incr_PROD_955133480        NBU       /db01
NetBackup_full_PROD_9551329 52       NBU       /db01

To display other Storage Checkpoints without updating the repository

Use the dbed_ckptdisplay command as follows:

$ /opt/VRTS/bin/dbed_ckptdisplay -S PROD \
-H /oracle/product -o other -n

NetBackup_incr_PROD_955133480											NBU			/db01
NetBackup_full_PROD_9551329									52		NBU			/db01

To display all Storage Checkpoints

Use the dbed_ckptdisplay command as follows:

$ /opt/VRTS/bin/dbed_ckptdisplay -S PROD \
-H /oracle/product -o all

Checkpoint_971672042							Sun May 15 13:55:53 2005								C+R+IN

Checkpoint_903937870							Fri May 13 22:51:10 2005								C+R+ON

Checkpoint_901426272							Wed May 11 16:17:52 2005								P+R+ON

NetBackup_incr_PROD_955133480											NBU			/db01

NetBackup_full_PROD_9551329									52		NBU			/db01

To display all Storage Checkpoints without updating the repository

Use the dbed_ckptdisplay command as follows:

$ /opt/VRTS/bin/dbed_ckptdisplay -S PROD \
-H /oracle/product -o all -n

Checkpoint_971672042							Sun May 15 13:55:53 2005								C+R+IN

Checkpoint_903937870							Fri May 13 22:51:10 2005								C+R+ON

Checkpoint_901426272							Wed May 11 16:17:52 2005								P+R+ON

NetBackup_incr_PROD_955133480											NBU			/db01
NetBackup_full_PROD_9551329									52		NBU			/db01

To display fileset quota values

Use the dbed_ckptdisplay command as follows:

$ /opt/VRTS/bin/dbed_ckptdisplay -S PROD -c \
Checkpoint_903937870 -Q

Checkpoint_903937870								Wed Mar 19 9:12:20 2005								C+R+ON

Filesystem								   HardLim			SoftLim			CurrentUse

/oradata1/indx1_1				100000			 50000			  2028

/oradata1/user1_1				100000			 50000			  2028

/oradata1/temp							150000			 80000		  	2142

/oradata1/system1				150000			 70000			  3092

Prev	Up	Next
Scheduling Storage Checkpoint creation in a cron job	Home	Mounting Storage Checkpoints using dbed_ckptmount