Move Oracle Data File in SAP



Share this article :

1. Execute brtools command. Choose option 2 – Space Management.

BR*Tools main menu

 1 = Instance management
 2 - Space management
 3 - Segment management
 4 - Backup and database copy
 5 - Restore and recovery
 6 - Check and verification
 7 - Database statistics
 8 - Additional functions
 9 - Exit program

2. Select option 6 – Move data file.

Database space management

 1 = Extend tablespace
 2 - Create tablespace
 3 - Drop tablespace
 4 - Alter tablespace
 5 - Alter data file
 6 - Move data file
 7 - Additional space functions
 8 - Reset program status

3. Select option 3, to fill in the Tablespace names and select option 4, to fill Data file names.

BRSPACE options for move data file

 1 - BRSPACE profile (profile) ...... [initTR3.sap]
 2 - Database user/password (user) .. [/]
 3 ~ Tablespace names (tablespace) .. [PSAPSR3]
 4 ~ Data file names (file) ......... [/oracle/TR3/sapdata1/sr3_1/sr3.data1]
 5 - Confirmation mode (confirm) .... [yes]
 6 - Scrolling line count (scroll) .. [20]
 7 - Message language (language) .... [E]
 8 - BRSPACE command line (command) . [-p initTR3.sap xxxx]

4. Press ‘c’ to continue with the executions.

BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options....

5. Next, select option 3 – Move destination (destination) and select option 6 – Force instance shutdown to ‘yes‘.

Options for moving data file /oracle/TR3/sapdata1/sr3_1/sr3.data1

 1 * Current file size in MB (currsize) . [2000]
 2 * Current link target (currlink) ..... []
 3 - Move destination (destination) ..... [/installsoft/sapdata]
 4 ~ Raw disk / link target (rawlink) ... []
 5 - Parallel copy processes (parallel) . [1]
 6 - Force instance shutdown (force) .... [yes]
 7 - SQL command (command) .............. [alter database rename file xxx]

6. Press ‘c’ again to continue. Wait the process to be done. Check the space of your operating system level to verify this.

BR0280I BRSPACE time stamp: 2011-04-15 15.51.08
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2011-04-15 15.51.08
BR0370I Directory /oracle/TR3/sapreorg/sefrawcz created
..
...
....
BR0202I Copying /oracle/TR3/sapdata1/sr3_1/sr3.data1
BR0203I to /installsoft/sapdata/sr3_1/sr3.data1 ...

#FILE..... /oracle/TR3/sapdata1/sr3_1/sr3.data1
#COPIED... /installsoft/sapdata/sr3_1/sr3.data1

BR0280I BRSPACE time stamp: 2011-04-15 15.56.55
BR0063I 1 of 1 file processed - 2000.008 MB of 2000.008 MB done
BR0204I Percentage done: 100.00%, estimated end time: 15:56
BR0001I **************************************************
.....
......
.......
###############################################################################

BR0292I Execution of BRSPACE finished with return code 0

Related posts

SARA: Archive Administration
Free Temse Used Space in SAP
Oracle 11g: Usage of hugepages on Linux
XPRA: No suitable RFC destination could be found
© 2017 ITsiti. All Rights Reserved
Powered by KEEM