Re: Control files inconsistent

We had this happen on an IRIX machine. We had 3 controlfiles, each on seperate disks. The machine crashed for unknown reasons. The database would not start up, and by trying to open the database with each individual controlfile (by editing init.ora), we found that all 3 controlfiles were NFG. Imagine that. We ended up doing a "recover database using backup controlfile" and then "open resetlogs" (using RMAN) We've had Solaris machines crash like this, and the database always came up just fine after crash recovery. A couple weird things like this happened on IRIX machines, which sort of soured us on oracle on SGI.
 Diana

"Howard J. Rogers" wrote:
>
> Theoretically, you can use the version numbers contained in the error
> messages to tell you which is the "correct" version of the control file, but
> I've had odd results with that, so this is the patented Rogers method of
> resolving the issue.
>
> 1. Edit the initi.ora. Change control_files to point to a single
> controlfile (say, you control01 one).
> 2. Try and start the database. If it succeeds, you know that file is the
> good one.
> 3. If it doesn't succeed, we suspect it to be the bad one, but just to be
> sure...
> 4. Shutdown immediate
> 5. Edit the init.ora. Change the parameter to point to the other
> controlfile.
> 6. Try and start the database.
>
> 7. Now you know which is the good version, and which the bad, shutdown
> immediate and copy the good version over the bad.
> 8. Edit the init.ora so it points to both files once more
> 9. Startup.
>
> It's possible both copies will fail to open the database, in which case you
> are into either (1) performing a 'recover database using backup controlfile'
> followed by a resetlogs or (2) running the 'create controlfile' script
> available to you from previously having run 'alter database backup
> controlfile to trace' (you *do* run that command regularly, I hope??!). And
> if neither of those options is viable, you can then (1) investigate manually
> typing in a version of the 'create controlfile' command (and pray) and (2)
> wonder why your backup and recovery strategy seems to be at sizes and
> sevens.
>
> Regards
> HJR
> --
> =============================!!=============================
> The views expressed are my own only, and definitely NOT those of Oracle
> Corporation
> =============================!!=============================
>
> "Chuck Carson" <rhugga_at_yahoo.com> wrote in message
> news:3b13ed54.6728505_at_news.qwest.net...
> >
> > I received this error after starting a database after a blackout
> > crashed the box.
> >
> > ORA-00214: controlfile '/odata/ora03/oradata/ora/control02.ctl'
> > version 343522 inconsistent with file
> > '/odata/ora02/oradata/ora/control01.ctl' version 341611
> >
> >
> > WHat are my options to bring this database back online?
> >
> > Thanks,
> > CC
Received on Thu May 31 2001 - 14:08:39 CDT