Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

Database Dynamic Storage Tiering use cases for
Oracle
Use cases were created in order to provide examples of how and why you would
use Database Dynamic Storage Tiering.
Migrating partitioned data and tablespaces
Perhaps the simplest application of multi-tier storage to databases is relocation
of individual table partitions between different placement classes as usage
requirements change. If exact relocation times are unpredictable, or if relocation
is infrequent, administrators may wish to relocate table partitions as business
requirements surface rather than defining strict periodic relocation schedules.
Ad hoc relocation of table partitions can be useful, for example, with databases
that track sales and inventory for seasonal businesses such as sports equipment
or outdoor furniture retailing. As the selling season for one type of inventory (for
example, summer equipment or furniture) approaches, database table partitions
that represent in-season goods can be relocated to high-performance storage,
since they will be accessed frequently during the coming months. Similarly,
partitions that represent out-of-season goods can be relocated to lower-cost
storage, since activity against them is likely to be infrequent.
For example, sales are mostly catalog-driven for a large retailer specializing in
sports equipment. Product details are saved in a large database and the product
table is partitioned based on type of activity. Some of the products are seasonal
and do not sell well at other times. For example, very few snow skis are sold during
the summer. To achieve season-based migration, see the following example.
Assume the table product_tab has two partitions, summer and winter. Each of
these partitions is mapped to a separate data file.
First, you must set up your system to use Database Dynamic Storage Tiering.
To add the fast_storage and slow_storage storage classes
◆
Use the dbdst_admin command as follows:
$ /opt/VRTS/bin/dbdst_admin -S PROD -o addclass=\
fast_storage:"Fast Storage for Production DB"
$ /opt/VRTS/bin/dbdst_admin -S PROD -o addclass=\
slow_storage:"Slow Storage for Production DB"
203Using Database Dynamic Storage Tiering
Database Dynamic Storage Tiering use cases for Oracle