VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 8, Using Storage Checkpoints and Storage Rollback
Prerelease 8 September 2005, 8:55am Storage Checkpoint Allocation Policies
169
◆ Storage checkpoint allocation policy requires VxVM Volume Set and VxFS Multi-Volume File
Systems features to be enabled. These features are included in the Enterprise Edition of
Storage Foundation. Refer to the Multi-Volume File System chapter in the VERITAS File
System Administrator's Guide, for creating Volume Sets and MVS file systems for the primary
file systems used by the database datafiles.
◆ Data allocation is done by the volumes in the order that was assigned in the policy.
◆ The maximum length of an checkpoint policy name is 64 characters.
Using Storage Checkpoint Allocation Policies
You can use the dbed_ckptpolicy command to administrate the storage checkpoint allocation
policies. For detailed information on administrating Storage Checkpoint Policy via the CLI, see
“VERITAS Storage Foundation for Oracle Command Line Interface” on page 418.
Note You cannot administer Storage Checkpoint Allocation policies through the VxDBA utility
menu or the GUI.
Usage Notes
See the dbed_ckptpolicy(1M) and dbed_ckptcreate(1M) manual pages for more
information. dbed_ckptpolicy command need to be executed by the Oracle database
administrator.
In the following example, the file systems for database datafiles are set up as follows:
◆ Two MVS file systems /mvsfs/v1 and /mvsfs/v2 used for database 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.
◆ Volume set mvsvset2 contains volumes mvsv4 and mvsv5.
Usage
Use the dbed_ckptpolicy command with the following options.
$ dbed_ckptpolicy -S ORACLE_SID [ -H ORACLE_HOME ] [-n] [-h] options
Where options could be any of the following parameters:
-o create|update|remove -p ckpt_sample
-o display [-c ckpt_name | -p ckpt_sample]
-o assign -c ckpt_name -p ckpt_data_policy[,ckpt_metadata_policy]