Home » RDBMS Server » Server Administration » ORA-00214: controlfile error
ORA-00214: controlfile error [message #383924] Sat, 31 January 2009 07:31 Go to next message
rocky05
Messages: 3
Registered: January 2009
Junior Member
Hi all,

i am have a serious problem with my oracle 9i database:

when i try to start it up , i get the following error:

ORA-00214: controlfile 'C:\ORACLE\ORADATA\ORCL\CONTROL01.CTL' version 19177
inconsistent with file 'C:\ORACLE\ORADATA\ORCL\CONTROL03.CTL' version 19175


can anyone please help me with a possible solution to the above error?

thank you in advance,
rocky
Re: ORA-00214: controlfile error [message #383926 is a reply to message #383924] Sat, 31 January 2009 09:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Drop the number 3 and copy number 1 to 3.
But it is useless to have 3 control files in the same directory, so you can just drop it and update parameter file.

Regards
Michel

[Updated on: Sun, 01 February 2009 04:38]

Report message to a moderator

Re: ORA-00214: controlfile error [message #383968 is a reply to message #383924] Sun, 01 February 2009 03:27 Go to previous message
rocky05
Messages: 3
Registered: January 2009
Junior Member
Thankyou very much for your speedy response Michel, i followed your instructions and now am able to use my database. Smile

Thankyou once again for your help !

rocky
Previous Topic: Upgrading from 9i to 10g
Next Topic: table fragmentation
Goto Forum:
  


Current Time: Sat Dec 10 18:36:48 CST 2016

Total time taken to generate the page: 0.07469 seconds