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;

7 comments:

David Williams said...

Thanks for Information Oracle Online Training Oracle is an object-relational database management system created and marketed by Oracle Corporation.Oracle Online Training

Path Infotech said...

Thanks for sharing the information

Oracle DBA Certification

Melisa said...

Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
Regards,
Oracle Training in Chennai|Oracle DBA Training in Chennai

rsrs said...
This comment has been removed by the author.
erpcharan said...

Thanks for sharing the useful information about the oracle control file and good points were mentioned in the blog.

oracle fusion said...

I would like to appreciate your work for good accuracy and got informative knowledge from here.

Oracle Fusion financial

oracle fusion said...

I would like to appreciate your work for good accuracy and got informative knowledge from here.

Oracle Fusion financial

 

Oracle DBA Tutorial Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates