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

$ /opt/VRTS/bin/dbdst_classify -S $ORACLE_SID \
-M /dev/vx/dsk/oradg/ora_vset -v vol1:GOLD,vol2:GOLD,vol3:GOLD
For example:
$ /opt/VRTS/bin/dbdst_classify -S VRTS11r2 \
-M /dev/vx/dsk/dstdatadgot/datavol -v datavol1:FAST,datavol2:MEDIUM
It is important to note that, an MVFS can have multiple storage tiers and that
each tier may have a different chunk size. For example, for the same MVFS in the
above example, we can define another storage tier using the dbdst_classify
command:
$ /opt/VRTS/bin/dbdst_classify -S $ORACLE_SID \
-M /dev/vx/dsk/oradg/ora_vset -v vol4:silver,vol5:silver
For example:
$ /opt/VRTS/bin/dbdst_classify -S VRTS11r2 \
-M /dev/vx/dsk/dstarchdgot/archvol -v archvol1:FAST,archvol2:MEDIUM
At this point we have two storage tiers in MVFS /oradata each having different
chunksizes. To create the real extent balance, we need to assign a SmartTier policy
and enforce it.
To define and enforce the policy, you could use the following
dbdst_preset_policy command:
$/opt/VRTS/bin/dbdst_preset_policy -S $ORACLE_SID \
-d /oradata -P GOLD=*.dbf:SILVER=*.inx
The above example creates a SmartTier policy, assigns the policy to /oradata and
enforces the policy. All datafiles of the form *.dbf will be extent balanced in GOLD
tier with chunksize 256K and all index files of the form *.inx will be extent balanced
in SILVER tier with chunk size 128K.
Another example:
$ /opt/VRTS/bin/dbdst_preset_policy -S VRTS11r2 \
-d /data11r2/VRTS11r2 -P "MEDIUM=temp*.dbf:FAST=*.log"
Assign placement policy file successful on filesystem /data11r2
Begin enforcing filesystem /data11r2 ...
Enforce placement policy successful on filesystem /data11r2
To view the space usage in the /oradata MVFS use the dbdst_show_fs command.
For example:
263Configuring and administering SmartTier
Extent balancing in a database environment