7 Move Oracle Control File

Move an Oracle control file.

How to Move an Oracle Control File E:\DATABASE\CONTROL03.CTL to F:\DATABASE\CONTROL03.CTL?.

Two methods depending on the configuration PFILE or SPFILE in place.

If you use the static parameter file PFILE.

Edit the PFILE is appointing initSID.ora, change the setting in there CONTROL_FILES modifying the file path control. E: \ DB1 \ CONTROL03.CTL to F: \ DB1 \ CONTROL03.CTL

CONTROL_FILES = ('C:\Oracledba\oradata\test_database\control.ctl'  
'D:\DATABASE\CONTROL02.CTL'
'F:\DATABASE\CONTROL03.CTL')

SQL> shutdown immediate;

Then Cut / Paste the file control (or HOST MOVE) E:\DATABASE\CONTROL03.CTL to F:\DATABASE\CONTROL03.CTL then restart the database.

SQL> HOST MOVE

E:\DATABASE\CONTROL03.CTL F:\DATABASE\CONTROL03.CTL;

SQL> STARTUP

SQL> SHOW PARAMETER CONTROL_FILES;

If you use the server parameter file SPFILE.

 SQL> ALTER SYSTEM SET CONTROL_FILES = 'C:\Oracledba\oradata\test_database\control.ctl',
 'D:\DATABASE\CONTROL02.CTL',
'F:\DATABASE\CONTROL03.CTL' SCOPE = SPFILE;

SQL> shutdown immediate;

Then Cut / Paste the file control (or HOST MOVE) E: \ DB1 \ CONTROL03.CTL to F: \ DB1 \ CONTROL03.CTL then restart the database.

SQL> HOST MOVE E:\DATABASE\CONTROL03.CTL F:\DATABASE\CONTROL03.CTL;

SQL> STARTUP

SQL> SHOW PARAMETER CONTROL_FILES;