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

to query the AWR and generate trend reports. You can use AWR to get file usage
trends and relocate least used files to secondary storage tier.
Advantages of using file statistics from AWR:
■ AWR file stats are available by default. No extra configuration is needed.
■ In a clustered environment, AWR file stats include IO from all the nodes. There
is no need to collect from each node and sum it up.
■ AWR file statistics provides history and hence it is easy to get the usage trends.
AWR also provides Oracle Object level statistics like segment statistics. These can
be used to find out the least used table segments.
See “Using AWR statistics to identify sub-file objects for potential relocation”
on page 275.
SmartTier in a High Availability (HA) environment
The DiskGroup agent brings online, takes offline, and monitors a Veritas Volume
Manager (VxVM) disk group. This agent uses VxVM commands. When the value
of the StartVolumes and StopVolumes attributes are both 1, the DiskGroup agent
onlines and offlines the volumes during the import and deport operations of the
disk group. When using volume sets, set StartVolumes and StopVolumes attributes
of the DiskGroup resource that contains the volume are set to 1. If a file system
is created on the volume set, use a Mount resource to mount the volume set.
The Mount agent brings online, takes offline, and monitors a file system or NFS
client mount point.
If you are using any of the SmartTier for Oracle commands in a high availability
(HA) environment, the time on each system in the cluster must be synchronized.
Otherwise, the scheduled task may not be executed at the expected time after a
service group failover.
Understanding storage tiering with SmartTier
SmartTier in a High Availability (HA) environment
244