VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Appendix A, VERITAS Storage Foundation for Oracle Command Line Interface
Prerelease 8 September 2005, 8:55am Examples of Using the Command Line Interface
439
Creating and Working with Storage Checkpoint Allocation Policies
Using dbed_ckptpolicy
You can use the VERITAS Storage Foundation for Oracle dbed_ckptpolicy command to
create and administer Storage Checkpoint allocation policies for Multi-Volume File Systems
(MVSs). Storage Checkpoint allocation policies specify a list of volumes and the order in which to
allocate data to them.
Prerequisites
◆ You must be logged on as the database administrator (typically, the user ID oracle).
Usage Notes
◆ All volumes must be MVSs.
◆ The dbed_ckptpolicy command can be used only on file systems using disk layout
Version 6.
◆ The VxVM volume set and VxFS Multi-Volume File System features must be enabled to use
Storage Checkpoint allocation policies.
◆ The status of a Storage Checkpoint allocation policy is either partial or complete. A
partial policy is one that does not exist on all file systems used by the database. A complete
policy is one that exists on all file systems.
◆ After an allocation policy is assigned to a Storage Checkpoint, the allocation mechanism
attempts to satisfy requests from each device in the order specified in the allocation policy. If
the request cannot be satisfied from any of the devices in the allocation policy, the request will
fail, even if other devices that have space exist in the file system. Only devices listed in the
policy can be allocated.
◆ See the dbed_ckptpolicy(1M) manual page for more information.
▼ To create a Storage Checkpoint allocation policy
Use the dbed_ckptpolicy command as follows:
$ /opt/VRTS/bin/dbed_ckptpolicy -S ORACLE_SID \
-o create -p ckpt_policy
Output similar to the following is displayed. This example assumes the following:
◆ Two MVS file systems /mvsfs/v1 and /mvsfs/v2 are used for datafiles.
◆ File system /mvsfs/v1 is created on volume set mvsvset1.
◆ File system /mvsfs/v2 is created on volume set mvsvset2.
◆ Volume set mvsvset1 contains volumes mvsv1, mvsv2, and mvsv3.