Re: ORA-00214 How to resolve control version inconsisten problem ?

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>...


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

> > ORA-00214: controlfile 'A01.ctl' version 733 inconsistent with file

 'A02.ctl


> >

> >     What can I do to make my ORACLE DB alive again ....??


> >

> >     Please help me .... thank you..

> >

> > -wls-