Home > Veritas Storage Foundation™ for Oracle Manual Pages
DBDST_FILE_MOVE (1M) |
|
Maintenance Commands |
Table of contents
dbdst_file_move - move the specified database object or a specific
list of files to the desired storage class if they have not been
accessed for certain period.
dbdst_file_move
-S
ORACLE_SID
-o { archive[n]|flashback } -c storage-class:days
dbdst_file_move
-S
ORACLE_SID
-o external -f spec-file -c storage-class:days
dbdst_file_move
-S
ORACLE_SID
-o datafile -f spec-file -c storage-class
dbdst_file_move
-S
ORACLE_SID
-o { archive[n]|flashback } -R
dbdst_file_move
-S
ORACLE_SID
-o external -f spec-file -R
Veritas Storage Foundation for Oracle.
To determine whether this product is installed on a Solaris system, enter:
pkginfo -l VRTSdbed
The dbdst_file_move command is used to move the specified database object
or a specific list of files to the desired storage class if they have not been
accessed for certain period. For datafiles, this command relocates the specified
files in spec-file into the desired storage-class immediately. For
archive and external files, this command schedules a sweep task to be executed at
sweeptime specified via dbdst_admin. For external files and datafiles,
all the files and directories included in the spec-file should reside
on a single filesystem.
The archive[n], should corrospond to archive1 to archive10 and corrosponding
LOG_ARCHIVE_DEST_N value from v$archive_dest will be taken. This archive_dest path
must be valid and active. The database must be ARCHIVE mode as indicated by
v$database view.
For flashback, database version must be 10gR1 and above.
The following options are supported:
-
.\" $Id: dbdst_options.inc,v 1.1 2006/02/16 01:33:08 susanl Exp $
-
-S ORACLE_SID
Specifies the name of the Oracle database whose information will be retrieved.
-
-o archive[n]
-
Specifies to move the archive log files. The values must be archive1 to archive10.
These corresponds to log_archive_destN from v$archive_dest view. This option
should not be used together with the -f option. The storage class specified should be
of the form -c <starage_class>:<days>.
-
-o flashback[n]
-
Specifies to move flashback log files. This option is supported for Oracle version
10gR1 and beyond only. This option should not be used together with the -f option.
The storage class specified should be of the form -c <starage_class>:<days>.
-
-o external
-
Specifies to move external files or datafiles. This option should be used
together with -f option. The storage class specified should be of the form
-c <starage_class>:<days>.
-
-o datafile
-
This option specifies to do a immediate relocation of datafiles specified in spec-file
to the desired class.This option should be used together with -f option. The storage class specified
should be of the form -c <starage_class> only.
-
-f spec-file
-
Specifies a filename which contains a list of files or directories to move.
The command will check the access right of each file specified in listfile
before actually moving the files. If caller of this command does not have
access right on any of the file specified in the listfile, command will exit
with error. This option should not be used together with the
-o {archive | flashback}.
-
-c storage-class:days
-
Specifies the storage class that the files will be moved to. If days is
supplied, it will be moved to class if file has not been accessed in days
number of days.
-
-R
-
This option specifies to remove the current DBDST policy on archive, flashback, datafile or
external file.
This command must be run as Oracle DBA user.
This command can be executed when the database is online.
dbed_update
must be run at least once before this command to ensure an up-to-date repository.
Please set LD_LIBRARY_PATH to include /opt/VRTSdbms3/lib32
-
0
-
Command executed successfully.
-
1
-
An Error Occured.
-
101
-
Licence check failed.
-
102
-
No license to execute this command.
-
103
-
Invalid Storage Class
-
104
-
The device or mount point is not owned by user
-
105
-
Could not get information from Oracle Database
-
255
-
Could not load program.
dbdst_classify(1M),
dbdst_admin(1M),
dbdst_convert(1M),
dbdst_tbs_move(1M),
dbdst_fstat(1M),
dbdst_makelbfs(1M),
dbdst_partition_move(1M),
dbdst_preset_policy(1M),
dbdst_report(1M),
dbdst_rmvol(1M),
dbdst_show_fs(1M),
dbdst_addvol(1M),
oracle_edition(7)
Veritas Storage Foundation for Oracle Administrator's Guide
Last updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.