Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

Table 11-3
dbdst_file_move command options (continued)
DescriptionOption
Specifies the storage class to which the files should be moved.
If the days option is used, the files will be moved to the class
specified if they have not been accessed in the number of
days specified. Do not specify days if you are using the -o
datafile option.
-c class[:days]
Removes the policy for the specified object.-R
Before relocating a file, review the following information:
■ Multiple partitions cannot reside on the same tablespace.Usage notes
To relocate a file
◆
Use the dbdst_file_move command as follows:
/opt/VRTS/bin/dbdst_file_move -S $ORACLE_SID -o datafile \
-f listfile -c storage_class
For example
$ /opt/VRTS/bin/dbdst_file_move -S FLAS10r2 -o datafile \
-f /home/external.spec -c MEDIUM
Assign placement policy file successful on filesystem /snap_data10r2
Begin enforcing filesystem /snap_data10r2 ...
Enforce placement policy successful on filesystem /snap_data10r2
Relocating tablespaces
Use the dbdst_tbs_move command to move tablespaces to the desired storage
class. The command queries the SFDB repository for the tablespace file names,
then performs a one-time move based on your immediate requirements.
To relocate a tablespace
◆
Use the dbdst_tbs_move command as follows:
$ /opt/VRTS/bin/dbdst_tbs_move -S $ORACLE_SID -t tablespace \
-c class
where
197Using Database Dynamic Storage Tiering
Dynamic Storage Tiering policy management