Database startup fails due to ORA-00600 [kcbtema_11] (Doc ID 1372837.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 29-Jun-2013***

Symptoms

ORA-00600: internal error code, arguments: [kcbtema_11], [2224690], [2224704], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/magprd/magprd1/incident/incdir_458836/magprd1_p011_17128_i458836.trc
Fri Oct 14 11:15:03 2011
Errors in file /u01/app/oracle/diag/rdbms/magprd/magprd1/trace/magprd1_p010_17124.trc (incident=458828):


TRACE FILE

Call Stack Trace
----------------
kcbtema kcrpap kcrpdv kxfprdp opirip ...

Changes

The database was running in "hot backup" mode for long time.
The scenario below will illustrate this in more detail:

SCENARIO

Tue Oct 04 00:30:40 2011
alter database begin backup
Completed: alter database begin backup
Fri Oct 14 11:11:55 2011
Starting ORACLE instance (normal)
...

Fri Oct 14 11:12:00 2011
ALTER DATABASE MOUNT
...

Completed: ALTER DATABASE MOUNT
Fri Oct 14 11:12:06 2011
ALTER DATABASE OPEN
...
Errors in file /u01/app/oracle/diag/rdbms/magprd/magprd1/trace/magprd1_ora_15136.trc:
ORA-10873: file 1 needs to be either taken out of backup mode or media recovered
ORA-01110: data file 1: '+DATA/magprd/datafile/system.272.713218625'
ORA-10873 signalled during: ALTER DATABASE OPEN...
ALTER DATABASE RECOVER
Media Recovery Start
started logmerger process
Parallel Media Recovery started with 16 slaves
Fri Oct 14 11:12:17 2011
SUCCESS: diskgroup ARCHIVE was mounted
ORA-279 signalled during: ALTER DATABASE RECOVER ...
Fri Oct 14 11:14:14 2011
ALTER DATABASE RECOVER CANCEL
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Fri Oct 14 11:14:30 2011
ALTER DATABASE END BACKUP
Completed: ALTER DATABASE END BACKUP
Fri Oct 14 11:14:55 2011
alter database open
...

Completed redo scan
read 1111070 KB redo, 41638 data blocks need recovery
Started redo application at
Thread 1: logseq 71586, block 10152
Thread 2: logseq 37123, block 1050777, scn 93575045622
Thread 3: logseq 39115, block 13976
Thread 4: logseq 53926, block 1894426
Recovery of Online Redo Log: Thread 1 Group 30 Seq 71586 Reading mem 0
Mem# 0: +REDO/magprd/onlinelog/group_30.267.764427003
Mem# 1: +REDO/magprd/onlinelog/group_30.266.764427013
Recovery of Online Redo Log: Thread 2 Group 33 Seq 37123 Reading mem 0
Mem# 0: +REDO/magprd/onlinelog/group_33.270.764427211
Mem# 1: +REDO/magprd/onlinelog/group_33.271.764427221
Recovery of Online Redo Log: Thread 3 Group 35 Seq 39115 Reading mem 0
Mem# 0: +REDO/magprd/onlinelog/group_35.261.764430367
Mem# 1: +REDO/magprd/onlinelog/group_35.273.764430377
Recovery of Online Redo Log: Thread 4 Group 37 Seq 53926 Reading mem 0
Mem# 0: +REDO/magprd/onlinelog/group_37.274.764433523
Mem# 1: +REDO/magprd/onlinelog/group_37.275.764433533
Fri Oct 14 11:15:03 2011
Errors in file /u01/app/oracle/diag/rdbms/magprd/magprd1/trace/magprd1_p011_17128.trc (incident=458836):
ORA-00600: internal error code, arguments: [kcbtema_11], [2224690], [2224704], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/magprd/magprd1/incident/incdir_458836/magprd1_p011_17128_i458836.trc
Fri Oct 14 11:15:03 2011
Errors in file /u01/app/oracle/diag/rdbms/magprd/magprd1/trace/magprd1_p010_17124.trc (incident=458828):
...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms