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
/ora/testvol04 25000 20000 128
/ora/testvol05 50000 40000 128
Note
CurrentUse displays the number of filesystem blocks currently used by all Storage Checkpoints in the filesystem. If there are no Storage Checkpoints, or if quotas have been disabled, CurrentUse will display 0.
|