Home > Veritas Storage Foundation™ for Oracle Manual Pages
DBDST_PRESET_POLICY (1M) |
|
Maintenance Commands |
Table of contents
dbdst_preset_policy - set policy based on file name patterns before the file is created.
dbdst_preset_policy
-S
ORACLE_SID
-d
directory
-e | -R |
-P
pattern_spec
\[ -E ] |
-f
pattern_file
\[ -E ] |
-l
Veritas Storage Foundation for Oracle.
To determine whether this product is installed on a Solaris system, enter:
pkginfo -l VRTSdbed
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.
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.
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/VRTSdbcom/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/VRTSdbcom/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.
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.
Please set LD_LIBRARY_PATH to include /opt/VRTSdbms3/lib32
-
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.
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.