Moving Oracle Datafile Using BRtools in Solaris or Linux

The Following Steps will move the Oracle datafile from old location to new location

• Login as "su - oraSID"
  

• Enter command brtools
  

• Select 2 - Space management.

• Then Select 6 - Move data file.
  

• Select 3 ~ Tablespace names (tablespace) .. []And provide the table space name, Example " PSAPSR3700" etc.
  

• Select 4 ~ Data file names (file) ......... [] and enter the detail of the datafile which you want to move, Example = "/oracle/SID/sapdata1/sr3700_3/sr3700.data3
  

Please note the new destination should have the name starting with "sapdataXX" the location can be any where.

• Enter "c" continue 2 times

• Select 3 ~ Move destination and enter destination, Example=" /oracle/SID/sapdata1/".

• And Select 6 Force instance shutdown and enter yes

• Enter "c"

This is just a simple example and please refer to SAP note for exact steps to move Oracle data file through Brtools