Re: Help resurecting an instance

From: Stan Brown <stanb_at_panix.com>
Date: 18 Aug 2001 08:58:44 -0400
Message-ID: <9lloq4$c24$1@panix1.panix.com>

In <3b7dd7b5.2094870885_at_172.22.22.15> gedau_at_munged.to.reduce.spam (George Dau) writes:

>stanb_at_panix.com (Stan Brown) wrote:

>]I have an old v7 db installed on one of my home machines. Recently I had a
>]disk crash, and restored one of the hard disk. Now when I do dbstart, I get
>]the following error messages:
>]
>]ORA-00214: controlfile '/oracle/oradata/stan/control01.ctl' version 1413
>]inconsistent with file '/local/oradata/stan/control02.ctl' version 1397
>]
>]The db was not runing in archivelog mode.
>]
>]Given that the contents of non system data in the db don't matter, what can
>]I do to get this db back up and runing?

>They are control files.
>rename control02.ctl as a backup, then copy control01.ctl as control02.ctl

Thanks, that got me part way, now I'm getting:

ORA-00314: log 2 of thread 1, expected sequence# doesn't match ORA-00312: online log 2 thread 1: '/local/oradata/stan/redostan02.log'

What do I do next? Received on Sat Aug 18 2001 - 07:58:44 CDT