1, shutdown database.
2, edit Oracle init.ora file, e.g., C:\Oracle\10g\database\inittest.ora, find the line with control file location, change the location from old directory to new directory, e.g.:shutdown immediate;
OLD:
control_files=("H:\Oradata\test\control01.ctl")
NEW:
control_files=("I:\Oradata\test\control01.ctl", "J:\Oradata\test\control02.ctl", "K:\Oradata\test\control03.ctl")
save init.ora file.
3, create spfile from pfile:
create spfile from pfile;
4, Copy control files from old directory to new directory
copy H:\Oradata\test\control01.ctl
I:\Oradata\test\control01.ctl copy H:\Oradata\test\control01.ctl J
:\Oradata\test\ control02.ctlcopy H:\Oradata\test\control01.ctl K:\Oradata\test\control03.ctl
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>
0 comments:
Post a Comment