How to move Oracle control files to different directory
(No Ratings Yet)
Loading ...1, shutdown database.
shutdown immediate;
2, edit Oracle init.ora file, e.g., C:\Oracle\admin\Unanet\pfile, find the line with control file location, change the location from old directory to new directory, e.g.:
OLD:
control_files=("H:\Oradata\Unanet\Unanet\control01.ctl", "H:\Oradata\Unanet\Unanet\control02.ctl", "H:\Oradata\Unanet\Unanet\control03.ctl")
NEW:
control_files=("J:\Oradata\Unanet\control01.ctl", "J:\Oradata\Unanet\control02.ctl", "J:\Oradata\Unanet\control03.ctl")
save init.ora file.
3, create spfile from pfile:
create spfile from file='C:\Oracle\admin\Unanet\pfile\init.ora';
4, Copy control files from old directory to new directory
copy H:\Oradata\Unanet\Unanet\*.ctl J:\Oradata\Unanet
5, startup database.
SQL> startup
ORACLE instance started.
Total System Global Area 1426063360 bytes
Fixed Size 2004264 bytes
Variable Size 352324312 bytes
Database Buffers 1056964608 bytes
Redo Buffers 14770176 bytes
Database mounted.
Database opened.
SQL>
Popularity: 2%
