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:

Unknown said...

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

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.

Tourism in India said...

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

Oracle Fusion financial

Tourism in India said...

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

Oracle Fusion financial

Jaideep Singh said...

Hello,
I read your blog and it was very interesting and useful for me. I am very thankful to you for these types of blogs and i wish you can post like this.
Thank you.

 

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