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

queries Oracle dba_extents catalog table and for each extent gets file offest and
lengh in bytes. This command passes these offset/length information to VxFS
low level SmartTier commands to move the database extents to desired storage
class.
Usage for dbdst_obj_view
dbdst_obj_move -S ORACLE_SID -H ORACLE_HOME [-v] -t table \
[-s start_extent] [-e end_extent] -c storage_class
dbdst_obj_move -S ORACLE_SID -H ORACLE_HOME [-v] -i index \
[-s start_extent] [-e end_extent] -c storage_class
dbdst_obj_move -S ORACLE_SID -H ORACLE_HOME [-v] -p partition \
[-s start_extent] [-e end_extent] -c storage_class
■ The database must be online.
■ The command must be run as Oracle user.
Prerequisites
■ To make sure the SFDB repository is up-to-date, run
dbed_update at least once before using the command.
Notes
■ This command can be run on any node of an Oracle RAC cluster
on which the database is running.
For Oracle RAC
environments
Table 14-6 shows the sub-file object movement command options.
Table 14-6
dbdst_obj_move command options
DescriptionCommand option
Specifies the name of the Oracle database from
which information will be retrieved.
-S ORACLE_SID
Specifies the ORACLE_HOME for the database.-H ORACLE_HOME
This is an optional argument. If this option is
specified, a verification will be done after
moving each extent to the target storage class.
If the target storage class does not have enough
free space, some the the table extents may not
be moved.
-v
Name of the table for which view report needs
to be generated.
-t table name
Name of the index which must be relocated.-i index name
267Configuring and administering SmartTier
Administering SmartTier at the sub-file level