Moving Datafile Oracle Using BRtools in Solaris or Linux

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"