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

Dynamic Storage Tiering policy management
You can choose to manually relocate files or tablespaces, or you can use a preset
Dynamic Storage Tiering (DST) policy.
Relocating files
You can relocate flashback logs, archive logs, datafiles, and external files if the
files are no longer being used frequently. For example, if you maintain seasonal
data, you may choose to move the files when you are in different seasons.
Table 11-3 on page 194. shows the dbdst_file_move command options.
Table 11-3
dbdst_file_move command options
DescriptionOption
Specifies which archive logs or Flashback logs to move. Do
not use this option with the -f option. Flashback is supported
by Oracle 10g or later.
-o archive[n] |
flashback
Specifies whether to move external files or datafiles. Use
this option with the -f option.
-o external |
datafile
Specifies a listfile that contains a list of files or directories
to be moved.
-f listfile
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:days [-c storage_class:days]
Using Database Dynamic Storage Tiering
Dynamic Storage Tiering policy management
194