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

[Former Member]

Dear gentlemen,

The error occurred once I try to startup the database as follow,

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

I tried to run the command, u201Crecover database;u201D and I got the following,

SQL> recover database;

ORA-00283: recovery session canceled due to errors

ORA-12801: error signaled in parallel query server P014

ORA-00600: internal error code, arguments: [3020], [2], [121], [8388729], [],

[], [], []

ORA-10567: Redo is inconsistent with data block (file# 2, block# 121)

ORA-10564: tablespace PSAPUNDO

ORA-01110: data file 2: 'D:\ORACLE\ECP\SAPDATA3\UNDO_1\UNDO.DATA1'

ORA-10560: block type 'KTU SMU HEADER BLOCK'

Please advice.

Regards,

Ahmed Saber

[Former Member]

Dear All,

First of all many thanks for all of you,

The problem has been resolved via restore the corrupted files from the backup from windows level and applied database recovery, and the steps already mentioned below,

SQL> shutdown

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup mount ;

ORACLE instance started.

Total System Global Area 2332033024 bytes

Fixed Size 2165768 bytes

Variable Size 1187935224 bytes

Database Buffers 1140850688 bytes

Redo Buffers 1081344 bytes

Database mounted.

SQL> recover database;

ORA-00283: recovery session canceled due to errors

ORA-12801: error signaled in parallel query server P014

ORA-00600: internal error code, arguments: [3020], [2], [105], [8388713], [],

[], [], []

ORA-10567: Redo is inconsistent with data block (file# 2, block# 105)

ORA-10564: tablespace PSAPUNDO

ORA-01110: data file 2: 'D:\ORACLE\ECP\SAPDATA3\UNDO_1\UNDO.DATA1'

ORA-10560: block type 'KTU SMU HEADER BLOCK'

SQL> recover database;

ORA-00283: recovery session canceled due to errors

ORA-12801: error signaled in parallel query server P008

ORA-00600: internal error code, arguments: [3020], [32], [260874], [134478602],

[], [], [], []

ORA-10567: Redo is inconsistent with data block (file# 32, block# 260874)

ORA-10564: tablespace PSAPSR3700

ORA-01110: data file 32: 'D:\ORACLE\ECP\SAPDATA3\SR3700_9\SR3700.DATA9'

ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK'

SQL> recover database;

Media recovery complete.

SQL> alter database open;

Database altered.

SQL>

Regards,

Ahmed Saber

[Former Member]

Dear Ahmed Saber,

I told the same that i felt soem thing wrong with PSAPUNDO tablespace.

great and thanks for sharing the experience.

thanks,

Chaitanya

[Former Member]

Dear Ahmed Saber ,

I feel there is some problem in the tablespace PSAPUNDO. Please check the data files status for PSAPUNDO when the database in in mount state.

Thanks,

Chaitanya.

[Former Member]

Follow the process given below:

1. Shutdown (A neat proper shutdown)

2. Startup mount

3. Recover database

4. Alter database open

[Former Member]

Hi Mark & Sunil Bujade,

The same result are occurred,

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> startup mount ;

ORACLE instance started.

Total System Global Area 2332033024 bytes

Fixed Size 2165768 bytes

Variable Size 1187935224 bytes

Database Buffers 1140850688 bytes

Redo Buffers 1081344 bytes

Database mounted.

SQL> recover database;

ORA-00283: recovery session canceled due to errors

ORA-12801: error signaled in parallel query server P014

ORA-00600: internal error code, arguments: [3020], [2], [121], [8388729], [],

[], [], []

ORA-10567: Redo is inconsistent with data block (file# 2, block# 121)

ORA-10564: tablespace PSAPUNDO

ORA-01110: data file 2: 'D:\ORACLE\ECP\SAPDATA3\UNDO_1\UNDO.DATA1'

ORA-10560: block type 'KTU SMU HEADER BLOCK'

Regards,

Ahmed Saber

[Former Member]

Hi,

Are u trying to restore and recover from a backup ? When do u actually receive this message ?

As per the oracle note 146580.1, this error occurs if the restore has not yet completed successfully. try to restore the backup completely and then recover the datbase again.

Good Luck.

Regards,

Varadharajan M

[former_member188883]

Hi,

You might have done the following.

1) Restored online backup

2) Have not applied all the redo log files required for complete recovery.

3) Force fully made oracle database up.

Above 3 steps leads to incomplete recovery of oracle database leading to the error message faced by you.

Only solution here is to restore the online backup again and apply all the redo logs for complete recovery.

Regards,

Deepak Kori

[Former Member]

Hi,

what version of Oracle you on..

Mark

[Former Member]

Hi Mark,

ORACLE RDBMS Version: 10.2.0.4.0.

Regards,

Ahmed Saber

[Former Member]

Hi,

Also try :

shutdown immediate;

startup mount ;

recover database;

Then alter database open;

Mark