VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Examples of Using the Command Line Interface Prerelease 8 September 2005, 8:55am
442 VERITAS Storage Foundation for Oracle Administrator’s Guide
Administering Storage Checkpoint Quotas dbed_ckptquota
You can use the VERITAS Storage Foundation for Oracle dbed_ckptquota command to
administer file system quotas for Storage Checkpoint for an Oracle database from the command
line.
Prerequisites
◆ You must be logged on as the database administrator (typically, the user ID oracle).
◆ The VxDBA repository entry for the database must exist and the DBA must be the owner of all
file systems to be affected.
Usage Notes
◆ See the dbed_ckptquota(1M) manual page for more information.
▼ To set quota limits for all file systems in the database and enable quota enforcement
Use the dbed_ckptquota command as follows to set the hard and soft limits for all file systems
in the database and enable quota enforcement:
$ /opt/VRTS/bin/dbed_ckptquota -S PROD -H /ora10i \
-o set=50000,40000,enable
▼ To set quota limits for all file systems specified in a list file
Use the dbed_ckptquota command as follows:
$ /opt/VRTS/bin/dbed_ckptquota -S PROD -H /ora10i \
-o set=25000,20000 -f quotacfg
▼ To disable quota limits for a file system
Use the dbed_ckptquota command as follows:
$ /opt/VRTS/bin/dbed_ckptquota -S PROD -H /ora10i \
-o disable /ora/testvol03
▼ To display quota values for all file systems in the database
Use the dbed_ckptquota command as follows:
$ /opt/VRTS/bin/dbed_ckptquota -S PROD -H /ora10i \
-o display
Filesystem Hardlimit Softlimit CurrentUse
/ora/prod 50000 40000 136
/ora/testvol01 25000 20000 128
/ora/testvol02 50000 40000 128
/ora/testvol03 50000 40000 0