OraFAQ Forum: Backup & Recovery » Control file errors, ORA-00214

Home » RDBMS Server » Backup & Recovery » Control file errors, ORA-00214 (Oracle 10g R2, AIX 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Control file errors, ORA-00214 [message #480662]

Tue, 26 October 2010 04:30

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Pls. help me again.

Our production server encountered a hardware problem that led to our db server of not been restarted after repairing.
Everytime we tried to start the db, this error have been displaying:
ORA-00214: control file '<path/controlfile>' version 977908 inconsitent with '<path/controlfile>' version 977865

What I should do next?

Thank you in advance.

[EDITED by LF: fixed topic title; the original error code was "ORA-0012"]

[Updated on: Wed, 27 October 2010 01:08] by Moderator

Report message to a moderator

Re: Control file errors, re: ORA-0012 [message #480663 is a reply to message #480662]

Tue, 26 October 2010 04:35

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Remove the old one and copy the new one to the old one location.

Regards
Michel

Report message to a moderator

Re: Control file errors, re: ORA-0012 [message #480758 is a reply to message #480662]

Tue, 26 October 2010 21:11

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Sir, I already copied and "synch' all the control files from their respective path. But after I restarted the db again,
it give me this error: "ORA-00600: internal error code..."

Report message to a moderator

Re: Control file errors, re: ORA-0012 [message #480762 is a reply to message #480758]

Tue, 26 October 2010 22:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>it give me this error: "ORA-00600: internal error code..."

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

[Updated on: Tue, 26 October 2010 22:10]

Report message to a moderator

Re: Control file errors, re: ORA-0012 [message #480764 is a reply to message #480762]

Tue, 26 October 2010 22:43

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Thanks for this.

Regards.

Report message to a moderator

Re: Control file errors, ORA-00214 [message #480930 is a reply to message #480662]

Thu, 28 October 2010 03:38

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Sirs,

We restored our problematic production database this morning from backups after encountering the ORA-00600 error yesterday. Currently, we are encountering the ORA-00205 errors. Upon checking the alertlog, there are accompanying errors of ORA-00202, 27037 & 27047. We still cannot open the database after we overwrite good/existing controlfiles with those corrupted (we checked using DBVERIFY).

One thing I noticed was that one of the controlfile had a different name compared to the two. The prime controlfile located at this path /origlogA has a filename of "cntlrPRD.dbf",
while the rest have a filename of "cntrlPRD.dbf" which was located at /origlogB and /sapdata1 directories respectively.
I'm wondering now if this causes the error, because of inconsistency of the filename?

Our last option is to recreate the controlfile. My question is that, can I try to issue a command 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE' in one of our dev server? Is there any risks involved if I try it while the said database is open? I just want to see how the generated/backup file looks like.

Thank you very much.

Report message to a moderator

Re: Control file errors, ORA-00214 [message #480932 is a reply to message #480930]

Thu, 28 October 2010 03:59

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Hi - I'm not going to offer advice on fixing your problem, it would not be sensible to interfere without a full understanding of what happened and the current situation. But to answer your precise questions:
First, controlfile copies can be named anything at all. The inconsistency is of no significance.
Second, you can backup the controlfile to trace at any time.

Report message to a moderator

Re: Control file errors, ORA-00214 [message #480934 is a reply to message #480932]

Thu, 28 October 2010 04:04

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Thanks for this.

You've enlightened me of what's on my mind!

Best regards.

Report message to a moderator

Re: Control file errors, ORA-00214 [message #481001 is a reply to message #480662]

Fri, 29 October 2010 02:03

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Sir,

Btw, based on the ".trc" file created by using the 'alter database backup controlfile to trace', can I exclude those pertaining to datafiles (when I execute it as an SQL script)?
I just want to execute only on re-creating the redo logs and adding the character set.

Thanks again.

Report message to a moderator

Previous Topic:	Datafile recovery concept
Next Topic:	BAckup set,backup and backup piecec

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 19:12:21 CST 2024