Oracle 11g R2 Recovering database on Solaris 10 : ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr]

ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr]


I have an Oracle 11g R2 database on a Solaris 10. I got this error many times, it was due to Solaris illegal shutdown.

Here are the steps I performed to resolve this error

Launch SQL Plus from Oracle\bin folder ( not from Client folder)

SQL> conn sys/sys as sysdba

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

SQL> alter database recover;

Database altered.


SQL> alter database open;

alter database open

*

ERROR at line 1:

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

[136], [65730], [65738], [], [], [], [], [], [], []


SQL> shutdown immediate;

ORACLE instance shut down.


SQL> startup mount

ORACLE instance started.


SQL> alter database recover until cancel using backup controlfile;

alter database recover until cancel using backup controlfile

*

ERROR at line 1:

ORA-00279: change 3997604 generated at 02/11/2011 21:08:59 needed for thread 1
ORA-00289: suggestion :
C:\APP\RMANNI\RECOVERY_AREA\ORCLDB11G\ARCHIVELOG\2011_02_14\O1_MF_1_136_%U_.ARC
ORA-00280: change 3997604 for thread 1 is in sequence #136

Since my database is not running in archive log mode, I couldn't find the file specified in the above error message. I proceeded with the following

SQL> alter database recover continue default;

alter database recover continue default

*

ERROR at line 1:

ORA-00308: cannot open archived log

'C:\APP\RMANNI\RECOVERY_AREA\ORCLDB11G\ARCHIVELOG\2011_02_14\O1_MF_1_136_%U_.ARC'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.


SQL> alter database recover cancel;

Database altered.


If the above step errored out, then proceed with the lines shown below inbetween the dotted lines, if not


SQL> alter database open resetlogs;

Database altered.



SQL> Your database is good to go, You should now be able to connect


-----------If Alter database recover cancel Failed ------------------


SQL> alter database recover cancel;

alter database recover cancel

*

ERROR at line 1:

ORA-10879: error signaled in parallel recovery slave

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'C:\APP\RMANNI\ORADATA\ORCLDB\SYSTEM01.DBF'


SQL> recover database using backup controlfile until cancel;

ORA-00275: media recovery has already been started


SQL> shutdown immediate;

ORACLE instance shut down.


SQL> startup mount

ORACLE instance started.


Now, when you try to recover, Oracle will provide a suggestion,provide the path for your REDO log files. One of the log files will fix your database. I started with Redo03, but Redo01 fixed my database. You probably don't need to shutdown and restart the database for each Redo log flies.


SQL> recover database using backup controlfile until cancel;


ORA-00279: change 2448238 generated at 11/16/2010 22:05:53 needed for thread 1

ORA-00289: suggestion :

C:\APP\RMANNI\FLASH_RECOVERY_AREA\ORCLDB\ARCHIVELOG\2011_02_14\O1_MF_1_67_%U_.ARC

ORA-00280: change 2448238 for thread 1 is in sequence #67


Specify log: {=suggested
filename
AUTO
CANCEL}

C:\app\rmanni\oradata\ORCLDB\REDO03.LOG

ORA-00310: archived log contains sequence 66; sequence 67 required

ORA-00334: archived log: 'C:\APP\RMANNI\ORADATA\ORCLDB\REDO03.LOG'

ORA-10879: error signaled in parallel recovery slave

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'C:\APP\RMANNI\ORADATA\ORCLDB\SYSTEM01.DBF'


SQL> shutdown immediate;

ORACLE instance shut down.


SQL> startup mount

ORACLE instance started.


SQL> recover database using backup controlfile until cancel;

ORA-00279: change 2448238 generated at 11/16/2010 22:05:53 needed for thread 1

ORA-00289: suggestion :

C:\APP\RMANNI\FLASH_RECOVERY_AREA\ORCLDB\ARCHIVELOG\2011_02_14\O1_MF_1_67_%U_.ARC

ORA-00280: change 2448238 for thread 1 is in sequence #67


Specify log: {=suggested filename AUTO CANCEL}

C:\app\rmanni\oradata\ORCLDB\REDO02.LOG

ORA-00310: archived log contains sequence 65; sequence 67 required

ORA-00334: archived log: 'C:\APP\RMANNI\ORADATA\ORCLDB\REDO02.LOG'

ORA-10879: error signaled in parallel recovery slave

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'C:\APP\RMANNI\ORADATA\ORCLDB\SYSTEM01.DBF'


SQL> Shutdown immediate;

ORACLE instance shut down.


SQL> startup mount;

ORACLE instance started.


SQL> recover database using backup controlfile until cancel;

ORA-00279: change 2448238 generated at 11/16/2010 22:05:53 needed for thread 1

ORA-00289: suggestion :

C:\APP\RMANNI\FLASH_RECOVERY_AREA\ORCLDB\ARCHIVELOG\2011_02_14\O1_MF_1_67_%U_.ARC

ORA-00280: change 2448238 for thread 1 is in sequence #67


Specify log: {=suggested filename AUTO CANCEL}

C:\app\rmanni\oradata\ORCLDB\REDO01.log

Log applied.

Media recovery complete.


SQL> alter database open resetlogs;

Database altered.

-----------If Alter database recover cancel Failed ------------------

Share on Google Plus

About Veera

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.