Re: ORA-00214 How to resolve control version inconsisten problem ?
Date: 29 Apr 2002 13:38:38 -0700
Message-ID: <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:
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-
Received on Mon Apr 29 2002 - 22:38:38 CEST