Re: Urgent ORA-00600: internal error code

  • From: "Greg Norris" <spikey.mcmarbles@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 4 May 2007 07:41:38 -0500

On 5/4/07, John Dunn <JDunn@xxxxxxxxx> wrote:

 OK, I have recreated the control file but when I run RECOVER DATABASE
USING BACKUP CONTROLFILE I get the following errors.

I am not and never have been using archivelogs so why is it asking for
this file?

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE;

ORA-00279: change 406102834 generated at 05/02/2007 03:19:46 needed for
thread1

ORA-00289: suggestion :
/u03/app/oracle/product/9.2.0.1.0/dbs/arch1_1633.dbf

ORA-00280: change 406102834 for thread 1 is in sequence #1633



Specify log: {<RET>=suggested | filename | AUTO | CANCEL}


Unless this is a test (i.e. throwaway) database, I'd highly recommend that
you contact Oracle Support before going any further.  I don't mean any
offense, but you seem to be in over your head... database recovery really
isn't conducive to learning on-the-fly, as there are many possible
scenarios.

--
"I'm too sexy for my code." - Awk Sed Fred.

Other related posts: