Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

To view an audit report
◆
Use the dbdst_report command as follows:
$ /opt/VRTS/bin/dbdst_report -S $ORACLE_SID -o audit \
startdate=yyyy-mm-dd,enddate=yyyy-mm-dd
For example, to view an audit report of changes from January 1, 2006 through
March 1, 2006, use the dbdst_report command as follows:
$ /opt/VRTS/bin/dbdst_report -S $ORACLE_SID -o audit \
startdate=2006-01-01,enddate=2006-03-01
AUDIT DATETIME AUDIT DESCRIPTION
------------------- -------------------------------------------
02/10/2006-23:28:15 ADMIN;Added;class name=ONE
02/10/2006-23:28:16 ADMIN;Added;class name=TWO
02/10/2006-23:28:17 ADMIN;Added;class name=THREE
02/10/2006-23:28:18 ADMIN;Modified Successfully;max/min class=4/2,
statinterval=30, sweeptime=22:0, purgetime=20:0, swp/prg freq=1:30
02/10/2006-23:28:35 Convert;SUCCESS;Converting device
/dev/vx/dsk/eeedg/myvset mounted at /susanvset/myvset
02/10/2006-23:28:38 Addvol;SUCCESS;volume susan1 belongs to storage_class ONE
02/10/2006-23:28:41 Addvol;SUCCESS;volume susan3 belongs to storage_class TWO
Extent balancing in a database environment
To get better performance in a database environment, normally you would use a
volume striped over several disks. As the amount of data stored in the file system
increases over time, additional space in the form of new disks must be added.
To increase space, you could perform a volume relayout using the vxrelayout
command. However, changing a large volume from a four-way striped volume to
six-way striped volume involves moving old block information into temporary
space and writing those blocks from the temporary space to a new volume, which
takes a long time. To solve this problem, Veritas Storage Foundation for Oracle
offers a new feature called a Load Balanced File System (LBFS).
An LBFS is created on a multi-volume file system where individual volumes are
not striped over individual disks. For data-availability, these individual volumes
can be mirrored. The file system on the LBFS has a special placement policy called
a balance policy. When the balance policy is applied, all the files are divided into
small "chunks" and the chunks are laid out on volumes so that adjacent chunks
are on different volumes. The default chunk size is 1MB and can be modified.
Since every file contains chunks on all available volumes, it is important that
201Using Database Dynamic Storage Tiering
Extent balancing in a database environment