change the path of datafile,redolog,controlfile

the customer need to relocate the path of $ORADATA to diskarray partition which means that you need to change the path of controlfile,redolog,datafiles.

there is the example to solve this case:

1.generate a  new pfile using the spfile and change the path of controlfiles

remember to copy the controlfile to the new location

2.startup mount pfile=’/new_path/new_pfile.ora’

3.path mapping

/home/oracle/oradata/trade/system01.dbf ----> /oradata/trade/system01.dbf

/home/oracle/oradata/trade/sysaux01.dbf----->/oradata/trade/sysaux01.dbf

/home/oracle/oradata/trade/users01.dbf------> /oradata/trade/users01.dbf

/home/oracle/oradata/trade/temp01.dbf----->/oradata/trade/temp01.dbf

/home/oracle/oradata/trade/TRADE.dbf----->/oradata/trade/TRADE.dbf

/home/oracle/oradata/trade/undotbs01.dbf---->/oradata/trade/undotbs01.dbf

copy all the datafile to new path

Continue reading “change the path of datafile,redolog,controlfile”