Re: newbie screwup- db corrupt

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 17 Aug 2002 22:32:40 -0700
Message-ID: <92eeeff0.0208172132.51c80076@posting.google.com>

Any reason why you set your compatibilty parameter to 8.x for a 9.x database?
> I had a database I created in oracle 9.0.3 (compatibility set for 8).

You should have set your compatibility parameter to 9.0.3.0.0 for the original database.
> 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.

Not sure how you reached the conclusion that it had something to do with your redo log file when the error above clearly refers to your compatibility parameter.
> Well I went through many gyrations. I figured it had something to do
> with the redo logs remaining open or some unfinished business.

Your database is probably hosed with all the upgrades and downgrades. Install 9.2 and recreate your database with compatible = 9.0.3.0.0

//Rauf Sarwar Received on Sun Aug 18 2002 - 00:32:40 CDT