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

technology to correct any accidental errors quickly. The database generates large
number of archive logs per day. If the database goes down for any reason, there
is business requirement to bring the database back online and functional with in
15 minutes. To prevent Oracle log switch delays during transactions, the archive
logs need to be created in a fast EMC array. Archive logs older than a week can be
moved to a mid-range Clarion array. Archive logs older than 15 days can be moved
to slow JBOD disks. Archive logs are purged after 30 days. Current Flashback logs
are created manually by the database administrator on fast EMC storage and can
be moved to Clarion storage after two days. The database administrator then
deletes the Flashback logs after a week. To set up a system like this, see the
following example. Assume that archive logs and Flashback logs are created on
the same file system, /oralog. On the file system, /oralog/archive1 contains archive
logs and /oralog/flashback contains Flashback logs.
Figure 11-1 on page 202. illustrates a three-tier volume configuration that is suitable
for automatic relocation and deletion of archive logs and Flashback logs.
Figure 11-1
Database storage configuration suitable for automatic relocation
of archive and Flashback logs
The file system used by the production database in this example originally resides
on the single volume oralog, which must be prepared by adding volumes and
placement classes assigned to the volumes.
To add the NEW, MEDIUM, and OLD storage classes
◆
Use the dbdst_admin command as follows:
$ /opt/VRTS/bin/dbdst_admin -S PROD -o addclass=\
NEW:"EMC Storage for Production DB"
$ /opt/VRTS/bin/dbdst_admin -S PROD -o addclass=\
MEDIUM:"Clarion Storage for Production DB"
$ /opt/VRTS/bin/dbdst_admin -S PROD -o addclass=\
OLD:"JBOD Storage for Production DB"
Using Database Dynamic Storage Tiering
Database Dynamic Storage Tiering use cases for Oracle
202