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

Report message to a moderator

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: 68666
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 04:22:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.