Moving a Data File with BR*Tools

Context

You can use BR*Tools for Oracle to move a data file.

Note

This section describes how you move a data file with BR*Tools.

For more information on the approach to moving a data file, see Managing Data Files.

Procedure

Start the procedure using BRGUI or BRTOOLS, or from the command line:

BRGUI or BRTOOLS:

Choose Space Management Move data file .

BRGUI or BRTOOLS displays the menu BRSPACE options for move data file, where you specify the options with which you call BRSPACE.

Set the required options:

Menu Entry	Equivalent BRSPACE Command Option
BRSPACE profile (profile)	-p\|-profile
Database user/password (user)	-u\|-user
Tablespace names (tablespace)	-f dfmove -t\|-tablespace
Data file names (file)	-f dfmove -f\|-file
Confirmation mode (confirm)	-c\|-confirm
Scrolling line count (scroll)	-s\|-scroll
Message language (language)	-l\|-language
BRSPACE command line (command)	This shows you the BRSPACE -f dfmove command that is to be executed using the current settings.

Note

If required, in Data file names you can enter the names of multiple data files, but you cannot use wildcards. But this entry is optional.

For example, /oracle/GC2/sapdata3/users_1/users.data1, /oracle/GC2/sapdata4/xdb/xdb.data1 is a valid entry, but /oracle/GC2/sapdata* is not a valid entry.

You can also enter Oracle file IDs instead of path names.

Choose Continue.

BRGUI or BRTOOLS prompts you to start BRSPACE.
Choose Continue to start BRSPACE.

Command line:

Enter at least the following command:

brspace -f dfmove

You can enter more parameters, including the data file, if required. For more information, see BRSPACE -f dfmove.

Note
Whichever way you start the procedure - with BRGUI or BRTOOLS, or from the command line - you can use quick mode if you know the object name, in this case the data file name. For more information, see How to Use BR*Tools.

BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log.

BRSPACE displays the Move data file main menu.

If you have already entered the data file name, continue with step 5 (quick mode).

Note
If you have entered multiple data files, BRSPACE displays as confirmation a List of data files for moving. You cannot make a selection from this list. If required, go back and make a new selection.

Continue with step 5 (quick mode).

Choose Move data file.

BRSPACE displays the data file list:

List Entry	Meaning
Pos.	List sequence number
Tablespace	Tablespace name for the data file
Status	Data file status - online, offline, system, or recover
Type	Data file type - regular, raw disk, or ASM file
Size	Data file size
File	File name

Select a data file or multiple data files.

Example
These examples apply only to input in character mode.

To select the first three data files in the list, enter 1-3.

To select the first and third data files, enter 1,3.

To select the first three data files and the fifth, enter 1-3,5.

To select all entries, enter 0.

BRSPACE displays the menu, Options for moving data file.

Set the required options:

Menu Entry	Meaning
Current datafile size in MB (currsize) - display only	Current data file size
Current link target (currlink) - display only	Destination of link to a raw disk or to a non-sapdata directory, if any
Move destination (destination)	-f dfmove -d\|-destination
Raw disk / link target (rawlink)	-f dfmove -r\|-rawlink
Parallel copy processes (parallel)	-f dfmove -p\|-parallel
Force instance shutdown (force)	-f dfmove -f\|-force
SQL command (command)	The SQL command that is to be executed using the current settings. For more information, see your Oracle SQL documentation.

To start processing with the selected options, choose Continue.

Results

Check the results in the BRSPACE logs.

The summary log space<DBSID>.log displays the return code.
The detail log s<encoded timestamp>.dfm displays the details.
The structure change log struc<DBSID>.log logs all structure changes.

For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.