ORA-00600: internal error code, arguments: [KSLFDNG2], [0x0910BFB00], [0], [0x08EE2BAD8], [0x000000000], [], [], [], [], [], [], []

OS환경 : Oracle Linux 6.8 (64bit)

DB 환경 : Oracle Database 11.2.0.4

에러 : ORA-00600: internal error code, arguments: [KSLFDNG2], [0x0910BFB00], [0], [0x08EE2BAD8], [0x000000000], [], [], [], [], [], [], []

https://positivemh.tistory.com/434 테스트를 하던 중 alert log에서 ORA-00600 메세지 발견

Tue Feb 19 15:04:24 2019
Dumping diagnostic data in directory=[cdmp_20190219150424], requested by (instance=2, osid=6783), summary=[incident=78008].
Tue Feb 19 15:04:28 2019
Sweep [inc][78008]: completed
Sweep [inc2][78008]: completed
Tue Feb 19 15:04:35 2019
Errors in file /oracle/app/oracle/diag/rdbms/orcldb/ORCLDB2/trace/ORCLDB2_ora_6783.trc  (incident=78009):
ORA-00600: internal error code, arguments: [KSLFDNG2], [0x0910BFB00], [0], [0x08EE2BAD8], [0x000000000], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/orcldb/ORCLDB2/incident/incdir_78009/ORCLDB2_ora_6783_i78009.trc

ORA-00600 KSLFDNG2 발생

해당 trace 파일 확인

        [erType d]
[bktBuffer_ _coun]
[t_  xp_ eCache_ ]
[on_ FFFFCC28528 ]
[? 7FFFFCC28ACC ?]
[Unknown File Hea]
[der Version read]
[ for file number]
[ 11.ORA-01578: O]
[RACLE data block]
[ corrupted (file]
[ # 11, block # 3]
[).ORA-01110: dat]
[a file 11: '/dev]
[/raw/raw35'.stKG]
[E_kgsf()+71,0,0.]

파일 11968 라인에 block corrupted 메세지 발견 

해결 방법 : rman restore tablespace 후 recover tablespace

원인 : ORACLE data block corruption 때문에 발생한듯함

참조 : http://www.yallonking.com/?p=1166

(문서 ID 20847991.8)