Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)
To display all Storage Checkpoints
◆
Use the dbed_ckptdisplay command as follows:
$ /opt/VRTS/bin/dbed_ckptdisplay -S PROD \
-H /oracle/product/ORA_HOME -o all
Storage Checkpoint Creation Time Status
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/ORA_HOME -o all -n
Storage Checkpoint Creation Time Status
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
Storage Checkpoint Creation Time Status
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
Using Database Storage Checkpoints and Storage Rollback
Database Storage Checkpoint Commands
216