Re: error 600 with oracle 8.1.7 for linux

From: Andrew Hardy <Andrew.Hardy_at_AdvanticaTech.com>
Date: Mon, 18 Dec 2000 14:26:42 -0000
Message-ID: <91l6qn$f4c$1@sun-cc204.lut.ac.uk>

Have a look at:

ALTER DATABASE BACKUP CONTROLFILE TO TRACE ; You run this from svrmgr and it generates a control file creation script in your trace file. You modify the script as needed and then start the database in nomount. Run the script to rebuild the control file and you should then be able to open the database.

Andy
<ellisjb_at_my-deja.com> wrote in message news:91ds6p$edh$1_at_nnrp1.deja.com...
> In article <91d8ct$qal$1_at_sun-cc204.lut.ac.uk>,
> "Andrew Hardy" <Andrew.Hardy_at_AdvanticaTech.com> wrote:
> > Did you follow the upgrade instructions? Often, 2114 is associated
with
> > upgrades failing to upgrade the control file correctly. I suspect
that you
> > might need to recreate them.
>
> That seems to be the problem -- I created a new DB and when I use its
> control files in my init.ora, it works just fine.
>
> How can I rebuild my old control files?
>
> -Jonathan
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Dec 18 2000 - 08:26:42 CST