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
...
1. Start the procedure using BRGUI or BRTOOLS, or from the command line:
¡ BRGUI or BRTOOLS:
i. 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.
ii. 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.
iii. Choose Continue.
BRGUI or BRTOOLS prompts you to start BRSPACE.
iv. 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.
2. 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).
3. 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 or raw disk |
Size |
Data file size |
File |
File name |
4. 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.
5. 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. |
6. To start processing with the selected options, choose Continue.
Check the results in the BRSPACE logs.
· The summary log space<DBSID>.logdisplays 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 Logs and Profiles with BR*Tools.