Show TOC

-f dfmoveLocate this document in the navigation structure

This BRSPACE function moves a data file. For more information, see Moving a Data File with BR*Tools.

Function options:

  • -c|-force: forces database shutdown for move

    Default: do not force shutdown if a SAP user is connected

  • -d|-destination: specifies the destination for the move

    Syntax: -d|-destination <sapdata_dir>|<sapraw_dir>

    <sapdata_dir>|<sapraw_dir> specifies a sapdata or sapraw (UNIX only) directory

    Default: none, since you must always specify the move destination

  • -f|-file: specifies the data file name

    Syntax: -f|-file all_df|<file>|<file_id>|<file_id1>-<file_id2>| <sapdata_dir>|sapdata<N>|sapraw|<win_drive>:|+<asm_disk>|<file_list>

    all_df: all eligible data files (for example, from the specified tablespaces)

    <file>|<file_id>|<file_list>: specifies the data file(s) using the file names / IDS

    <sapdata_dir>|sapdata<N>|sapraw: specifies the data file(s) using sapdata / sapraw directory

    <win_drive>: specifies the data file(s) using the Windows disk drive letter

    +<asm_disk>: specifies the data file(s) using the ASM disk group

    Default: none, since you must always define the file name

  • -p|-parallel: specifies how many copy processes run in parallel to move multiple files

    Syntax: -p|-parallel <count>

    <count> specifies the number of parallel copy processes

    Default: 1, that is, a single process

  • -r|-rawlink: defines the destination of a raw disk or a link to a non- sapdata directory. This is defined as follows:

    • For a raw disk, the SAP convention is to create a softlink in the directory /oracle/<DBSID>/sapraw

    • For a link to a destination outside sapdata, such as to /oracle/temp, the new file directory is added as a symbolic link

    Syntax: -r|-rawlink <link target>

    <link target> specifies the link target

    Default: no raw link

  • -t|-tablespace: specifies the tablespace(s) for which data files are to be moved

    Syntax: -t|-tablespace <tablespace>|<tablespace_list>

    Default: none, but you can specify data files explicitly with option -f (see above)