Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie screwup- db corrupt

Re: newbie screwup- db corrupt

From: D.Y. <dyou98_at_aol.com>
Date: 18 Aug 2002 14:36:30 -0700
Message-ID: <f369a0eb.0208181336.2231d8dc@posting.google.com>


Assuming this is a test DB you used to test upgrade, why worry about recovering it? Wouldn't it be easier to start over and do it right?

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).
> 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 Sun Aug 18 2002 - 16:36:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US