一次ora-600 ktubko_1故障简单分析_dde problem key ora 600 kkogbro-优快云博客

这篇博客详细记录了一次Oracle数据库出现ora-600 ktubko_1错误的故障现象和分析过程。在数据库打开后，由于smon触发ora-600 ktubko_1错误导致实例宕机。通过alert log、block dump trace、undo header dump trace等手段进行故障排查，发现与ora-600 kcratr_nab_less_than_odr有关，最终通过10513时间屏蔽回滚和重建索引来解决故障。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

===================================================================================================
0. summary
 
    1. 故障现象
    2. 故障分析
    .   2.1 alert log
    .   2.2 block dump trace
    .   2.3 undo header dump trace
    .   2.4 undo block dump trace
    3. 故障处理
  
===================================================================================================
1. 故障现象


数据库open时报ora-600 kcratr_nab_less_than_odr, 这个错误很简单，根据call stack对比和mos描述基本接近，重建控制文件即可。mos参考如下：


Alter database open fails with ORA-00600 kcratr_nab_less_than_odr (文档 ID 1296264.1)


之后库打开后不多就就因为smon触发ora-600 ktubko_1导致实例宕。


===================================================================================================
2. 故障分析


*************************************************
2.1 alert log


Sat Jun 25 14:11:07 2016
Errors in file /u01/app/oracle/diag/rdbms/cwgkdb1/cwgkdb11/trace/cwgkdb11_smon_34408.trc  (incident=549070):
ORA-00600: internal error code, arguments: [ktubko_1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/cwgkdb1/cwgkdb11/incident/incdir_549070/cwgkdb11_smon_34408_i549070.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
ORACLE Instance cwgkdb11 (pid = 32) - Error 600 encountered while recovering transaction (1060, 17) on object 811985.   --- (usn, slot)
Errors in file /u01/app/oracle/diag/rdbms/cwgkdb1/cwgkdb11/trace/cwgkdb11_smon_34408.trc:
ORA-00600: internal error code, arguments: [ktubko_1], [], [], [], [], [], [], [], [], [], [], []
......
Sat Jun 25 14:16:09 2016
Errors in file /u01/app/oracle/diag/rdbms/cwgkdb1/cwgkdb11/trace/