RE: Urgent ORA-00600: internal error code

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}  

John    

From: John Dunn
Sent: 04 May 2007 10:50
To: 'Ghassan Salem'
Cc: oracle-l_at_freelists.org
Subject: RE: Urgent ORA-00600: internal error code

Thanks for the reply  

The redo logs are there(see below)  

How do I "recreate the control files and reset logs"  

-rw-rw---- 1 oracle9 oinstall 104858112 May 02 10:50 redo02.log

-rw-rw---- 1 oracle9 oinstall 104858112 May 02 03:19 redo01.log

-rw-rw---- 1 oracle9 oinstall 104858112 May 01 08:27 redo03.log
 

John      

From: Ghassan Salem [mailto:salem.ghassan_at_gmail.com] Sent: 04 May 2007 09:50
To: John Dunn
Cc: oracle-l_at_freelists.org
Subject: Re: Urgent ORA-00600: internal error code

This indicates a failure to find current redo logs, try to insure they are there, otherwise try to recreate the controil file and reset logs;

rgds

On 5/4/07, John Dunn <JDunn_at_sefas.com> wrote:

        Following the replacement of a disk I did a mksysb restore on a AIX 5.2 machine running Oracle 9.2          

        All the Oracle software, data files etc were on a tar tape that has also been restored.          

        But now when I try to startup Oracle I get the message          

        ORA-00600: internal error code, arguments: [3004], [1], [0], [0], [], [], [],

        []

        Does anyone have any advice or information on this error?                    

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 04 2007 - 06:33:16 CDT