Re: Control files inconsistent

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 29 May 2001 23:19:18 +0200
Message-ID: <3B141256.A08F017E@mytoys.de>

> I received this error after starting a database after a blackout
> crashed the box.
>
> ORA-00214: controlfile '/odata/ora03/oradata/ora/control02.ctl'
> version 343522 inconsistent with file
> '/odata/ora02/oradata/ora/control01.ctl' version 341611
>
> WHat are my options to bring this database back online?

I think, please Sybrand and Thomas Kyte correct me, if you don't have a third copy of your controlfile, you can move control01.ctl somewhere and copy control02.ctl to control01.ctl, because control02.ctl seems to be more up to date than control01.ctl.

Success,

Knut Received on Tue May 29 2001 - 16:19:18 CDT