VERITAS Storage Foundation 4.1 Oracle Administrator's Guide
Examples of Using the Command Line Interface Prerelease 8 September 2005, 8:55am
440 VERITAS Storage Foundation for Oracle Administrator’s Guide
◆ Volume set mvsvset2 contains volumes mvsv4 and mvsv5.
File System: /mvsfs/v2 (MVS volumes: mvsv4,mvsv5)
Assigned Data Policy: NONE (MVS Volumes: N/A)
Assigned Meta Data Policy: NONE (MVS Volumes: N/A)
Please enter the volume name(s), sperated by space, for the policy
ckpt_policy [skip,quit]: mvsv4
File System: /mvsfs/v1 (MVS volumes: mvsv1,mvsv2,mvsv3)
Assigned Data Policy: NONE (MVS Volumes: N/A)
Assigned Meta Data Policy: NONE (MVS Volumes: N/A)
Please enter the volume name(s), separated by space, for the policy
ckpt_policy [skip,quit]: mvsv2
The following information will be used to create policy ckpt_sample
ckpt_sample /mvsfs/v2 mvsv4
ckpt_sample /mvsfs/v1 mvsv2
▼ To display Storage Checkpoint allocation policy within the database
Use the dbed_ckptpolicy command as follows:
$ /opt/VRTS/bin/dbed_ckptpolicy -S ORACLE_SID \
-n -o display [-c storage_ckpt | -p ckpt_policy]
If -p ckpt_policy and -c storage_ckpt options are not specified, output similar to the
following is displayed:
Policy Name File System Coverage
-------------------- --------------------
ckpt Complete
ckpt_data Complete
ckpt_metadata Complete
new_ckpt Partial
ckpt_sample Complete
If -p ckpt_policy option is specified, output similar to the following is displayed:
Policy Name File System MVS volumes
---------------- ------------ -----------
ckpt_sample /mvsfs/v2 mvsv4
ckpt_sample /mvsfs/v1 mvsv2
If the -c storage_ckpt option is specified, output similar to the following is displayed:
Storage Checkpoint File System Data Policy Meta Data Policy
--------------------- ------------ ----------- ----------------
Checkpoint_1095125037 /mvsfs/v2 ckpt_data ckpt_metadata
Checkpoint_1095125037 /mvsfs/v1 ckpt_data ckpt_metadata