You can use BR*Tools for Oracle to move a data file.
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.
Start the procedure using BRGUI or BRTOOLS, or from the command line:
BRGUI or BRTOOLS:
Choose
.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) |
|
Database user/password (user) |
|
Tablespace names (tablespace) |
|
Data file names (file) |
|
Confirmation mode (confirm) |
|
Scrolling line count (scroll) |
|
Message language (language) |
|
BRSPACE command line (command) |
This shows you the BRSPACE -f dfmove command that is to be executed using the current settings. |
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.
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).
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.
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) |
|
Raw disk / link target (rawlink) |
|
Parallel copy processes (parallel) |
|
Force instance shutdown (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.
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.