ORA-600 kcratr_nab_less_than_odr和ORA-600 4194故障处理---惜分飞

客户一个11.2.0.1的库由于断电导致启动的时候报ORA-600 kcratr_nab_less_than_odr错误

---

Wed Aug 06 15:55:07 2025

ALTER DATABASE OPEN

Beginning crash recovery of 1 threads

 parallel recovery started with 27 processes

Started redo scan

Completed redo scan

 read 11787 KB redo, 4129 data blocks need recovery

Errors in file d:\app\xff\diag\rdbms\primary\orcl\trace\orcl_ora_3520.trc  (incident=2624321):

ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [111988], [42537], [43285], [], [], [], [], [], [], []

Incident details in: d:\app\xff\diag\rdbms\primary\orcl\incident\incdir_2624321\orcl_ora_3520_i2624321.trc

Aborting crash recovery due to error 600

Errors in file d:\app\xff\diag\rdbms\primary\orcl\trace\orcl_ora_3520.trc:

ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [111988], [42537], [43285], [], [], [], [], [], [], []

Errors in file d:\app\xff\diag\rdbms\primary\orcl\trace\orcl_ora_3520.trc:

ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [111988], [42537], [43285], [], [], [], [], [], [], []

ORA-600 signalled during: ALTER DATABASE OPEN...

类似的ORA-600 kcratr_nab_less_than_odr故障处理不少,但是应用redo完成之后,再open报错的不多:
12c启动报kcratr_nab_less_than_odr
又一例ORA-600 kcratr_nab_less_than_odr
ORA-600 kcratr_nab_less_than_odr故障解决
差点被误操作的ORA-600 kcratr_nab_less_than_odr故障
11.2.0.4库中遇到ORA-600 kcratr_nab_less_than_odr报错
但是这个客户比较不幸,经过一系列尝试打开数据库,但是报ORA-600 4194错误

Wed Aug 06 17:09:33 2025

ALTER DATABASE RECOVER  database until cancel using backup controlfile 

Media Recovery Start

 started logmerger process

Parallel Media Recovery started with 28 slaves

ORA-279 signalled during: ALTER DATABASE RECOVER  database until cancel using backup controlfile  ...

Wed Aug 06 17:10:17 2025

ALTER DATABASE RECOVER    LOGFILE 'D:\app\xff\oradata\orcl\REDO05.LOG' 

Media Recovery Log D:\app\xff\oradata\orcl\REDO05.LOG

Wed Aug 06 17:10:17 2025

Incomplete recovery applied all redo ever generated.

Recovery completed through change 2118813100 time 08/06/2025 15:02:15

Completed: ALTER DATABASE RECOVER    LOGFILE 'D:\app\xff\oradata\orcl\REDO05.LOG' 

Wed Aug 06 17:14:05 2025

alter database open resetlogs

Archived Log entry 188143 added for thread 1 sequence 111985 ID 0x634438e6 dest 1:

Archived Log entry 188144 added for thread 1 sequence 111986 ID 0x634438e6 dest 1:

Archived Log entry 188145 added for thread 1 sequence 111987 ID 0x634438e6 dest 1:

Archived Log entry 188146 added for thread 1 sequence 111984 ID 0x634438e6 dest 1:

Archived Log entry 188147 added for thread 1 sequence 111988 ID 0x634438e6 dest 1:

RESETLOGS after complete recovery through change 2118813100

Resetting resetlogs activation ID 1665415398 (0x634438e6)

Wed Aug 06 17:15:03 2025

Archived Log entry 188148 added for thread 1 sequence 1 ID 0x677cfac1 dest 1:

Successfully onlined Undo Tablespace 2.

Dictionary check beginning

Dictionary check complete

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is ZHS16GBK

No Resource Manager plan active

Errors in file d:\app\xff\diag\rdbms\primary\orcl\trace\orcl_smon_2428.trc  (incident=3264274):

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

Incident details in: d:\app\xff\diag\rdbms\primary\orcl\incident\incdir_3264274\orcl_smon_2428_i3264274.trc

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

Wed Aug 06 17:15:06 2025

QMNC started with pid=34, OS id=3052

LOGSTDBY: Validating controlfile with logical metadata

LOGSTDBY: Validation complete

Completed: alter database open resetlogs

后续由于该undo异常报ORA-01595和ORA-600 4194等错误导致数据库crash

Wed Aug 06 17:15:49 2025

Doing block recovery for file 3 block 888

Resuming block recovery (PMON) for file 3 block 888

Block recovery from logseq 2, block 316 to scn 2118813732

Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0

  Mem# 0: D:\APP\xff\ORADATA\ORCL\REDO02.LOG

Block recovery stopped at EOT rba 2.447.16

Block recovery completed at rba 2.447.16, scn 0.2118813732

Doing block recovery for file 3 block 1960

Resuming block recovery (PMON) for file 3 block 1960

Block recovery from logseq 2, block 316 to scn 2118813622

Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0

  Mem# 0: D:\APP\xff\ORADATA\ORCL\REDO02.LOG

Block recovery completed at rba 2.317.16, scn 0.2118813626

Errors in file d:\app\xff\diag\rdbms\primary\orcl\trace\orcl_smon_2428.trc:

ORA-01595: error freeing extent (2) of rollback segment (27))

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

接手这个库之后,处理工作相对比较简单,直接对异常undo进行重建即可

Thu Aug 07 09:35:08 2025

create undo tablespace undotbs2 datafile 'D:\APP\xff\ORADATA\ORCL\undotbs02.dbf' size 128M autoextend on

Completed: create undo tablespace undotbs2 datafile 'D:\APP\xff\ORADATA\ORCL\undotbs02.dbf' size 128M autoextend on

Thu Aug 07 09:37:53 2025

drop tablespace UNDOTBS1 including contents and datafiles

Deleted file D:\APP\xff\ORADATA\ORCL\UNDOTBS01.DBF

Completed: drop tablespace UNDOTBS1 including contents and datafiles

然后数据库报大量的ORA-600 kdsgrp1错误

Thu Aug 07 10:03:53 2025

Errors in file d:\app\xff\diag\rdbms\primary\orcl\trace\orcl_ora_6156.trc  (incident=5121829):

ORA-00600: 内部错误代码, 参数: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

Thu Aug 07 10:04:00 2025

Errors in file d:\app\xff\diag\rdbms\primary\orcl\trace\orcl_ora_4564.trc  (incident=5121501):

ORA-00600: 内部错误代码, 参数: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

Thu Aug 07 10:04:06 2025

Errors in file d:\app\xff\diag\rdbms\primary\orcl\trace\orcl_ora_9160.trc  (incident=5121837):

ORA-00600: 内部错误代码, 参数: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

Thu Aug 07 10:04:16 2025

Errors in file d:\app\xff\diag\rdbms\primary\orcl\trace\orcl_ora_5868.trc  (incident=5121821):

ORA-00600: 内部错误代码, 参数: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

Thu Aug 07 10:04:28 2025

Errors in file d:\app\xff\diag\rdbms\primary\orcl\trace\orcl_ora_4448.trc  (incident=5122077):

ORA-00600: 内部错误代码, 参数: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

* kdsgrp1-1: *************************************************

            row 0x013a9ae9.0 continuation at

            0x013a9ae9.0 file# 4 block# 3840745 slot 0 not found

KDSTABN_GET: 0 ..... ntab: 1

curSlot: 0 ..... nrows: 2

kdsgrp - dump CR block dba=0x013a9ae9

Block header dump:  0x013a9ae9

 Object id on Block? Y

 seg/obj: 0x31dd9  csc: 0x00.7dc0f246  itc: 2  flg: E  typ: 1 - DATA

     brn: 0  bdba: 0x13a9082 ver: 0x01 opc: 0

     inc: 2  exflg: 0

  

 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc

0x01   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000

0x02   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000

通过分析是由于index和表记录不匹配导致,对index进行重新rebuild完成本次修复任务.