Administering Storage Checkpoint quotas using dbed


Administering Storage Checkpoint quotas using dbed_ckptquota
Prev	Appendix B. Storage Foundation for Databases (SFDB) tools command line interface	Next

Administering Storage Checkpoint quotas using dbed_ckptquota

You can use the dbed_ckptquota command to administer file system quotas for Storage Checkpoint for a database from the command line.

Before administering Storage Checkpoint quotas, the following conditions must be met:

Prerequisites	You must be logged on as the database administrator (typically, the user ID oracle). The 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

The numbers in the "Hardlimit" and "Softlimit" columns represent the total numbers of file system blocks allowed.

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.

Prev	Up	Next
Unmounting Storage Checkpoints using dbed_ckptumount	Home	Performing Storage Rollback using dbed_ckptrollback