Re: newbie screwup- db corrupt

Comments embedded
<abc_at_iom.com> wrote in message
news:3d5e8347.237848017_at_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).

Why on earth?

> 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.

So you should have changed the compatible parameter to 9.0.3

>
> 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.
>

Your redo log files are now on 9.0.3 and your datafiles and the controlfiles and the compatible parameter is at 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?
>

If you don't have a backup and it's not running in archivelog, and you never issued
alter database backup controlfile to trace your only hope is you can make u a create controlfile script and run it manually.
Look in the sql reference manual for the exact syntax.

Other than that:
Requiescat in pacem for your database.
You should have prepared before you began.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address