If you want to load balance your datafile, you can split your datafile into another mount point,
here’s detail step.

1. lsnrctl stop
2. shutdown immediate
3. copy your datafile

cp /$ora_home/$SID/undo/undo01.dbf /$ora_home/$SID/undo1/
cp /$ora_home/$SID/undo/undo02.dbf /$ora_home/$SID/undo2/
cp /$ora_home/$SID/index1/idx01.dbf /$ora_home/$SID/index2/
cp /$ora_home/$SID/index1/idx02.dbf /$ora_home/$SID/index3/


4. startup exclusive mount
5. rename your old datafile path with alter command

alter db rename file ‘/$ora_home/$SID/undo/undo01.dbf’ to ‘/$ora_home/$SID/undo1/undo1.dbf’;
alter db rename file ‘/$ora_home/$SID/undo/undo02.dbf’ to ‘/$ora_home/$SID/undo2/undo2.dbf’;
alter db rename file ‘/$ora_home/$SID/index1/idx01.dbf’ to ‘/oradata/$SID/index2/idx01.dbf’;
alter db rename file ‘/$ora_home/$SID/index1/idx02.dbf’ to ‘/oradata/$SID/index3/idx02.dbf’;


6. shutdown immediate
7. startup
8. lsnrctl start

Note:
DB=database

You Should Also Check Out This Post:

More Active Posts: