newbie screwup- db corrupt

From: <abc_at_iom.com>
Date: Sat, 17 Aug 2002 17:29:36 GMT
Message-ID: <3d5e8347.237848017@news.sf.sbcglobal.net>

Ok, while learning Oracle 9i, I really screwed the pooch this time.

I had a database I created in oracle 9.0.3 (compatibility set for 8). I wanted to upgrade the server to release 9.2. Being the newbie that I am, I installed right over my original installation (and, yes, I looked in the manuals first).

After rebooting, my database fired up, I got a message to the effect that "compatible must be 9.0.3 or higher in order to use Automatic Segment Space Management". The database was mouunted but not open.

Well I went through many gyrations. I figured it had something to do with the redo logs remaining open or some unfinished business. I ended up reinstalling my old 9.0.3 software. No luck. When I did this and tried to open the instance, no matter what I logged in as, it said that I lacked the security privileges.

Now, I reinstalled 9.2 and give it another toss. Now when I try to open the database I get the message:

ORA-01571 -redo version 9.0.3.0.0 incompatible with Oracle Version 9.0.0.0.

Without giving you ALL the dirty details, any thoughts on how I might recover from this? Can you fix a broken database that you can't log into? Received on Sat Aug 17 2002 - 12:29:36 CDT