Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008

To add the fast_storage and slow_storage storage classes
◆
Use the dbdst_admin command as follows:
$ /opt/VRTS/bin/dbdst_admin -S PROD -o addclass=\
fast_storage:"Fast Storage for Production DB"
$ /opt/VRTS/bin/dbdst_admin -S PROD -o addclass=\
slow_storage:"Slow Storage for Production DB"
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 database’s 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 PROD -T product_tab \
-p winter -c fast_storage
$ /opt/VRTS/bin/dbdst_partition_move -S PROD -T product_tab \
-p summer -c slow_storage
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
200