My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.