Home » RDBMS Server » Server Administration » Control file (Windows 2012R2)
Control file [message #670090] Mon, 04 June 2018 12:50 Go to next message
sant_new1
Messages: 46
Registered: June 2014
Member
Hi Friends,

We have created a new 11gR2 instance on Windows 2012 R2. By mistake, control files are created with same names in 2 different disk - D:\oracle\oradata\prod\control01.ctl, E:\oracle\oradata\prod\control02.ctl, J:\oracle\oradata\prod\control02.ctl (instead of control03.ctl). Is it OK for Oracle to have same names for control files in different locations?

From my research, found that control file can be renamed. To rename the control file in J:\ to control03.ctl, please let me know if the below steps are correct

alter system set control_files='D:\oracle\oradata\prod\control01.ctl', 'E:\oracle\oradata\prod\control02.ctl','J:\oracle\oradata\prod\control03.ctl' scope=spfile;
shutdown immediate;
manually rename control file in the filesystem in J:\ to J:\oracle\oradata\prod\control03.ctl
startup

Please advice.

THank you so much in advance
Re: Control file [message #670091 is a reply to message #670090] Mon, 04 June 2018 12:55 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
It's perfectly OK to have Control Files with the same names in different locations, but it may be a bit confusing (or at least look unprofessional).

You procedure looks more or less right.

Good luck!
Re: Control file [message #670092 is a reply to message #670091] Mon, 04 June 2018 13:03 Go to previous messageGo to next message
sant_new1
Messages: 46
Registered: June 2014
Member
THank you so much
Re: Control file [message #670101 is a reply to message #670090] Tue, 05 June 2018 06:32 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Same question asked at https://community.oracle.com/thread/4149964
Previous Topic: oracle user does not see some data
Next Topic: DB Links may stop working after June 2019
Goto Forum:
  


Current Time: Thu Mar 28 05:05:14 CDT 2024