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

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 command 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 command 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.
SmartTier for Oracle translates these commands into SmartTier 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, SmartTier for Oracle 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.
SmartTier for Oracle sub-file use cases
The following sub-file based use cases are supported for SmartTier for Oracle:
■ Using AWR statistics to identify sub-file objects for potential relocation
■ Relocating a hot database segment to higher performance tier
SmartTier for Oracle use cases
SmartTier for Oracle sub-file use cases
274