Home > Veritas Storage Foundation™ for Oracle Manual Pages

DBDST_PRESET_POLICY (1)

User Commands

Table of contents


NAME

dbdst_preset_policy - set policy based on file name patterns before the file is created.

SYNOPSIS

dbdst_preset_policy -S ORACLE_SID -d directory -e | -R | -P pattern_spec \[ -E ] | -f pattern_file \[ -E ] | -l

AVAILABILITY

Veritas Storage Foundation for Oracle. To determine whether this product is installed on an \1 system, enter:

lslpp -L VRTSdbed


DESCRIPTION

The dbdst_preset_policy command is used to set placement policy based on file name patterns before the file is actually created. It also moves existing file with the specified patterns in the specified directory to the assigned class.

OPTIONS

The following options are supported:
.\" $Id: dbdst_options.inc,v 1.1 2006/02/16 01:33:08 susanl Exp $
-S ORACLE_SID Specifies the name of the Oracle database whose information will be retrieved.
-d directory
Specifies the directory that user wants to set the policy.
-e
Specify this option to enforce the file system of the specified directory again. In the case when there was an error in previous enforcement and DBA has fixed the problem. This option can be used to enforce again.
-R
Remove all the pattern based placement policies related to the specified directory.
-l
lists the existing policy that is set to the specified directory.
-P pattern_spec
specified file patterns and class assignment. Class assignment affects both existing and future files. Using this option, future files with specified pattern will be created in the specified class. Existing files with the specified pattern will be moved to the specified class. The pattern_spec can be specified using the following format. Note that the pattern_spec has to be enclosed by "". Wildcard can be used in pattern below but only 1 wildcard can be used in each pattern. "class=pattern,pattern,:class=pattern,pattern,:"
-f pattern_file
Specify a file which contains the class and pattern assignment. Using this option, future files with specified pattern will be created in the specified class. Existing files with the specified pattern will be moved immediately to the specified class. The pattern_file will contain one or more of the following line. Wildcard can be used in pattern below but only 1 wildcard can be used in each pattern. class=pattern,pattern,
-E
This option can be specified optionally with -P or -f option. By default if there is any existing file that matches the specified pattern in the specified directory, the file will be moved to the assigned class immediately. If -E is specified, the existing files will not be moved immediately to the assigned class. Instead, a one-time move will be scheduled at a later time to perform the move. The sweeptime specified in the dbdst_admin command is used as the time to schedule this one-time move.

Real Application Clusters (RAC) Considerations

This command is supported in a RAC environment. This command can be run on any node of the RAC.

EXAMPLES

This example shows how to create policy for a directory based on file name patterns specified in pattern_spec. Existing files which match the pattern will be moved immediately


$ /opt/VRTS/bin/dbdst_preset_policy -S ora10gr2 -d /ora/oradata -P "PRIMARY=*.DAT: SECONDAY=*.INX"

Future files in /ora/oradata with pattern *.DAT will be created in class PRIMARY and existing files with pattern *.DAT will be moved to class PRIMARY. Future files in /ora/oradata with pattern *.INX will be created in class SECONDARY and existing files with pattern *.DAT will be moved to class SECONDARY.

This example shows how to create policy using a pattern file. Using the -E option, existing files will not be moved immediately, instead it will be moved in the sweeptime specified in dbdst_admin command.


$cat ./pattern_file
PRIMARY=*.DAT
SECONDARY=*.INX

$ /opt/VRTS/bin/dbdst_preset_policy -S ora10gr2 -d /ora/oradata -f ./pattern_file -E

Future files in /ora/oradata with pattern *.DAT will be created in class PRIMARY and existing files with pattern *.DAT will be moved to class PRIMARY. Future files in /ora/oradata with pattern *.INX will be created in class SECONDARY and existing files with pattern *.INX will be moved to class SECONDARY. The existing files will be moved in the scheduled sweeptime.


NOTES

dbdst_preset_policy must be run as Oracle DBA user. This command can be executed when the database is down. dbed_update must be run at least once before this command to ensure an up-to-date repository. The -R option removes all policies for all file name patterns related to the specified directory. It cannot remove some patterns and keep the rest of them. If you want to keep some of the name patterns policies, you need to re-apply the policy for the file name patterns that you want to keep after using the -R option.


ENVIRONMENT

Please set LIBPATH to include /opt/VRTSdbms3/lib32


EXIT STATUS

0
Command executed successfully.
1
An Error Occured.
101
Licence check failed.
102
No license to execute this command.
103
Invalid Storage Class
104
The device or mount point is not owned by user
105
Could not get information from Oracle Database
255
Could not load program.

SEE ALSO

dbdst_classify(1M), dbdst_admin(1M), dbdst_convert(1M), dbdst_file_move(1M), dbdst_fstat(1M), dbdst_makelbfs(1M), dbdst_partition_move(1M), dbdst_preset_policy(1M), dbdst_report(1M), dbdst_rmvol(1M), dbdst_show_fs(1M), dbdst_addvol(1M), oracle_edition(7)

Veritas Storage Foundation for Oracle Administrator's Guide

Last updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.