Re: ORA-00214 How to resolve control version inconsisten problem ?
From: Frank <fbortel_at_home.nl>
Date: Tue, 30 Apr 2002 20:29:26 +0200
Message-ID: <3CCEE286.4010209_at_home.nl>
>>Looks like you two control files are not consistent.
>>
>>I am never doen this, but here is what you can try:
>>
>>1. Make a back up copy of both 'A01.ctl' and 'A02.ctl'
>>
>> We don't know which control file is "bad" and which one is "good", so
>>2. copy 'A01.ctl' to where 'A02.ctl' is , and rename it as 'A02.ctl'
>>
>>then try to start the db.
>>
>>If it works, this means your 'A02.ctl' was bad.
>>
>>If still not working, then it probably means your old 'A02.ctl' was good,
>>
>>'A01.ctl' was bad, so
>>
>>3. copy your backed (from step1) 'A02.ctl' to where 'A02.ctl' locates, and
>> copy your backed (from step1) 'A02.ctl' to where 'A01.ctl' locates,
>>then try to start the db.
>>
>>Hope this helps.
>>
>>Guang
>>
>>
>>
>>
>>
>>
>>"wls" <cuba_at_ms.chttl.com.tw> wrote in message
>>
>>>
>>>
>
>
Date: Tue, 30 Apr 2002 20:29:26 +0200
Message-ID: <3CCEE286.4010209_at_home.nl>
wls wrote:
> GM: > Thank you for your kind responding... > I follow your suggestion and get another error message... > And, it tell me to do media recovery :() > > Um... I did not starp up the archive log mode before.... > So.. is that means that the DB is gone forever? > Or there is other ways to recover the poor DB? > > -- > ------------------------------------------------ > "G M" <zlmei_at_hotmail.com> ????? > news:50a5e6b6.0204291238.6fae982e_at_posting.google.com... >
>>Looks like you two control files are not consistent.
>>
>>I am never doen this, but here is what you can try:
>>
>>1. Make a back up copy of both 'A01.ctl' and 'A02.ctl'
>>
>> We don't know which control file is "bad" and which one is "good", so
>>2. copy 'A01.ctl' to where 'A02.ctl' is , and rename it as 'A02.ctl'
>>
>>then try to start the db.
>>
>>If it works, this means your 'A02.ctl' was bad.
>>
>>If still not working, then it probably means your old 'A02.ctl' was good,
>>
> your >
>>'A01.ctl' was bad, so
>>
>>3. copy your backed (from step1) 'A02.ctl' to where 'A02.ctl' locates, and
>> copy your backed (from step1) 'A02.ctl' to where 'A01.ctl' locates,
>>then try to start the db.
>>
>>Hope this helps.
>>
>>Guang
>>
>>
>>
>>
>>
>>
>>"wls" <cuba_at_ms.chttl.com.tw> wrote in message
>>
> news:<aaitdq$6vc_at_netnews.hinet.net>... >>>>ORA-00214: controlfile 'A01.ctl' version 733 inconsistent with file
>>>Hi
>>>
>>> My machine was powered off suddenly without shuting oracle db down
>>>first.
>>>
>>> When I try to startup my Oracle db, it stop and show
>>>
> 'A02.ctl >>>>-wls-
>>> What can I do to make my ORACLE DB alive again ....??
>>>
>>> Please help me .... thank you..
>>>
>>>
>
>
recover database;
alter database open;
Received on Tue Apr 30 2002 - 20:29:26 CEST