Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

To create a preset policy
◆
Use the dbdst_preset_policy command as follows:
$ dbdst_preset_policy -S oracle_sid -d directory \
[ -e | -R | -l | -P pattern_spec | -f pattern_file ] [-E]
where pattern_spec has the format of
"class=pattern,pattern,...[:class=pattern,pattern,...]"
For example:
$ /opt/VRTS/bin/dbdst_preset_policy -S VRTS11r2 \
-d /data11r2/VRTS11r2 -P "MEDIUM=*.dbf:FAST=*.log"
Assign placement policy file successful on filesystem /data11r2
Begin enforcing filesystem /data11r2 ...
Enforce placement policy successful on filesystem /data11r2
Running SmartTier for Oracle reports
You can create a report that lists all updated allocation policies or you can view
an audit report, which lists recent relocation changes for a specific date range
resulting from your policies.
Viewing modified allocation policies
To create a list of modified allocation policies, use the dbdst_report command
with the policy option.
To list allocation policies
■ Use the dbdst_report command to view a list of modified allocation policies.
For example:
$ /opt/VRTS/bin/dbdst_report -S $ORACLE_SID -o policy
$ /opt/VRTS/bin/dbdst_report -S VRTS11r1 -o policy
TSDB Database Policy Report
-----------------------------------------------------------
Plan Name = preset_dir:/data11r1/VRTS11r1
Plan Type = PRESET POLICY DIRECTORY
Rule Name = DBED_precreate_ino4_PRIMARY
259Configuring and administering SmartTier
Running SmartTier for Oracle reports