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

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. SmartTier for Oracle
determines which files comprise the winter and summer partitions of product_tab,
and uses underlying SmartTier services to immediately relocate those files to the
fast_storage and slow_storage placement classes respectively.
To move winter data to slower storage and summer data to faster storage at the
beginning of summer
◆
Use the dbdst_partition_move command as follows:
$ /opt/VRTS/bin/dbdst_partition_move -S PROD -T product_tab \
-p summer -c fast_storage
$ /opt/VRTS/bin/dbdst_partition_move -S PROD -T product_tab \
-p winter -c slow_storage
SmartTier for Oracle formulates SmartTier policy rules that unconditionally
relocate the files containing the target partitions to the destination placement
classes. It merges these rules into the database file system’s active policy, assigns
the resulting composite policy to the file system, and enforces it immediately to
relocate the subject files. Because the added policy rules precede any other rules
in the active policy, the subject files remain in place until the dbdst_partition_move
command is next executed, at which time the rules are removed and replaced with
others.
Scheduling the relocation of archive and Flashback logs
Because they are the primary mechanism for recovering from data corruption,
database logs are normally kept on premium storage, both for I/O performance
and data reliability reasons. Even after they have been archived, logs are normally
kept online for fast recovery, but the likelihood of referring to an archived log
decreases significantly as its age increases. This suggests that archived database
logs might be relocated to lower-cost volumes after a certain period of inactivity.
271SmartTier for Oracle use cases
SmartTier for Oracle file-based use cases