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

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/oralog -v emc_v1,clarion_v1,jbod_v1
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/oralog -v emc_v1:NEW
$ /opt/VRTS/bin/dbdst_classify -S PROD \
-M /dev/vx/dsk/oradg/oralog -v clarion_v1:MEDIUM
$ /opt/VRTS/bin/dbdst_classify -S PROD \
-M /dev/vx/dsk/oradg/oralog -v jbod_v1:OLD
Once the volumes are configured, an administrator can define file placement
policy rules that specify access age-based relocation of selected files and assign
them to the database’s file system.
To define rules that periodically relocate Flashback and archive logs
◆
Use the dbdst_file_move command as follows:
$ /opt/VRTS/bin/dbdst_file_move -S PROD -o flashback -c MEDIUM:2
This relocates files in the Flashback directory that have not been accessed
for two days to the MEDIUM volume.
$ /opt/VRTS/bin/dbdst_file_move -S PROD -o archive1 -c MEDIUM:7 \
-c OLD:15
This relocates files in the archive1 directory that have not been accessed for
seven days to the MEDIUM volume, and files that have not been accessed for
15 days to the OLD volume.
Database Dynamic Storage Tiering translates these commands into DST access
age-based policy rules, merges them with the file system’s placement policy, and
assigns the resulting policy to the file system. By default, Database Dynamic
Storage Tiering enforces the active policy daily. During enforcement, the new
rules relocate qualifying files to the destination storage tiers specified in the
dbdst_file_move commands used to create the policies.
203Using Database Dynamic Storage Tiering
Database Dynamic Storage Tiering use cases for Oracle