![]() |
< Previous | Next > |
Product: Oracle Manual Pages for Storage Foundation | |
Manual: Maintenance Commands (1m) |
dbed_ckptpolicyNAMEdbed_ckptpolicy - create or administer Storage Checkpoint allocation policies SYNOPSISdbed_ckptpolicy -S ORACLE_SID [ -H ORACLE_HOME ] [-n] [-h ] -o create | update | remove -p ckpt_policy_name dbed_ckptpolicy -S ORACLE_SID [ -H ORACLE_HOME ] [-n] [-h ] -o display [-c ckpt_name | -p ckpt_policy_name] dbed_ckptpolicy -S ORACLE_SID [ -H ORACLE_HOME ] [-n] [-h ] -o assign -c ckpt_name -p ckpt_data_policy[,ckpt_metadata_policy] AVAILABILITYVERITAS Storage Foundation for Oracle. To determine whether this product is installed on a HP-UX system, enter: DESCRIPTIONYou can use the dbed_ckptpolicy command to create and administer Storage Checkpoint allocation policies. Storage Checkpoint allocation policies specify a list of volumes and the order in which to allocate data to them. You can use Storage Checkpoint allocation policies to:
When allocation policies are assigned to a Storage Checkpoint, the DBA must specify the mapping for both Storage Checkpoint metadata and file data. If no allocation policies are specified for the Storage Checkpoint, the data is allocated randomly within the primary file system. Storage Checkpoint data and metadata can have different allocation policies assigned to them or use the same policy. Moreover, the same allocation policy can be assigned to multiple Storage Checkpoints. 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. OPTIONSThe following options are supported: Specifies the name of the Oracle database for which a Storage Checkpoint allocation policy will be created. Specifies the name of ORACLE_HOME. Disables VxDBA repository refresh. By default, dbed_ckptpolicy will refresh the VxDBA repository if this option is not used. Specifies whether to create, update, or remove a Storage Checkpoint allocation policy. Specifies the name of the Storage Checkpoint allocation policy. Displays the Storage Checkpoint allocation policy. Specifies the name of the Storage Checkpoint. Assigns an allocation policy to the specified Storage Checkpoint. -p ckpt_data_policy[,ckpt_metadata_policy] The -p ckpt_data_policy option specifies the name of the allocation policy to assign to Storage Checkpoint data. The -p ckpt_metadata_policy option optionally specifies the name of the allocation policy to assign Storage Checkpoint metadata. EXAMPLESIn examples below assume the following:
This example shows how to create a Storage Checkpoint allocation policy: $ /opt/VRTS/bin/dbed_ckptpolicy -S PROD -o create -p ckpt_sample 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_sample [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), sperated by space, for the policy ckpt_sample [skip,quit]: mvsv2 The following information will be used to create policy ckpt_sample ckpt_sample /mvsfs/v2 mvsv4 ckpt_sample /mvsfs/v1 mvsv2 A partial policy is allowed in defining the policy for the storage checkpoint. A partial policy means the policy does not exist on all file system used by database. This example shows how to display Storage Checkpoint allocation policies within the database: $ /opt/VRTS/bin/dbed_ckptpolicy -S PROD -n -o display Policy Name File System Coverage -------------------- -------------------- ckpt Complete ckpt_data Complete ckpt_metadata Complete new_ckpt Partial ckpt_sample Complete "Partial" indicate that one or more of the file systems used by the database does not contain the named policy. This example shows how to display information for a specific allocation policy: $ /opt/VRTS/bin/dbed_ckptpolicy -S PROD -n -o display -p ckpt_sample Policy Name File System MVS volumes ---------------- -------------------------------- ----------- ckpt_sample /mvsfs/v2 mvsv4 ckpt_sample /mvsfs/v1 mvsv2 This example shows how to display the allocation policies assigned to a specified Storage Checkpoint: $ /opt/VRTS/bin/dbed_ckptpolicy -S PROD -n -o display -c Checkpoint_1095125037 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 This example shows how to update a Storage Checkpoint allocation policy: $ /opt/VRTS/bin/dbed_ckptpolicy -S PROD -n -o update -p ckpt_sample File System: /mvsfs/v2 (MVS volumes: mvsv4,mvsv5) Policy: ckpt_sample (MVS volumes: mvsv4) Please enter the volume name(s), sperated by space, for the policy ckpt_sample [skip,quit]: mvsv5 File System: /mvsfs/v1 (MVS volumes: mvsv1,mvsv2,mvsv3) Policy: ckpt_sample (MVS volumes: mvsv2) Please enter the volume name(s), sperated by space, for the policy ckpt_sample [skip,quit]: mvsv2,mvsv3 The following information will be used to create policy ckpt_sample ckpt_sample /mvsfs/v2 mvsv5 ckpt_sample /mvsfs/v1 mvsv2,mvsv3 This example shows how to assign an allocation policy to an existing Storage Checkpoint: $ /opt/VRTS/bin/dbed_ckptpolicy -S PROD -n -o assign -c Checkpoint_1096060202 -p ckpt_data,ckpt_metadata $ /opt/VRTS/bin/dbed_ckptpolicy -S PROD -n -o display -c Checkpoint_1096060202 Storage Checkpoint File System Data Policy Meta Data Policy --------------------- -------------------------------- ---------------- ---------------- Checkpoint_1096060202 /mvsfs/v2 ckpt_data ckpt_metadata Checkpoint_1096060202 /mvsfs/v1 ckpt_data ckpt_metadata ![]() NOTESdbed_ckptpolicy must be run as the Oracle DBA. 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 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. The maximum length of a Storage Checkpoint allocation policy name is 64 characters. SEE ALSOdbed_ckptdisplay (1M), dbed_ckptmount (1M), dbed_ckptplan (1M), dbed_ckptquota (1M), dbed_ckptremove (1M), dbed_ckptrollback (1M), dbed_ckptumount (1M), dbed_update (1M), dbed_clonedb (1M), dbed_vxdba (1M), oracle_edition (7) VERITAS Storage Foundation for Oracle Administrator's Guide |
^ Return to Top | < Previous | Next > |
Product: Oracle Manual Pages for Storage Foundation | |
Manual: Maintenance Commands (1m) | |
VERITAS Software Corporation
www.veritas.com |