Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

To convert the database's file system and add volumes for use with Database
Dynamic Storage Tiering
Use the dbdst_convert command as follows:
$ /opt/VRTS/bin/dbdst_convert -S PROD \
-M /dev/vx/dsk/oradg/oradata -v new_vol1,new_vol2,new_vol3
To classify volumes into storage classes
Use the dbdst_classify command as follows:
$ /opt/VRTS/bin/dbdst_classify -S PROD \
-M /dev/vx/dsk/oradg/oradata -v new_vol1:fast_storage
$ /opt/VRTS/bin/dbdst_classify -S PROD \
-M /dev/vx/dsk/oradg/oradata -v new_vol2:slow_storage,\
new_vol3:slow_storage
Once the volumes are configured, an administrator can define file placement
policy rules that specify seasonal relocation of selected tablespaces and partitions
and assign them to the databases file system.
To move summer data to slower storage and winter data to faster storage at the
beginning of winter
Use the dbdst_partition_move command as follows:
$ /opt/VRTS/bin/dbdst_partition_move -S FLAS10r2 -T product_tab \
-p winter -c fast_storage
Assign placement policy file successful on filesystem /snap_data10r2
Begin enforcing filesystem /snap_data10r2 ...
Enforce placement policy successful on filesystem /snap_data10r2
$ /opt/VRTS/bin/dbdst_partition_move -S FLAS10r2 -T product_tab \
-p summer -c slow_storage
Assign placement policy file successful on filesystem /snap_data10r2
Begin enforcing filesystem /snap_data10r2 ...
Enforce placement policy successful on filesystem /snap_data10r2
These commands relocate the files that comprise the winter partition of the
product_tab table to placement class fast_storage, and the files that comprise the
summer partition to placement class slow_storage. Database Dynamic Storage
Tiering determines which files comprise the winter and summer partitions of
Using Database Dynamic Storage Tiering
Database Dynamic Storage Tiering use cases for Oracle
204