这篇博客详细记录了处理Oracle数据库出现ORA-00600内部错误，具体参数为[kcratr_nab_less_than_odr]的问题。故障可能是由于服务器宕机、控制文件缺失或在线日志不完整。在无法进行rman还原的情况下，博主通过将数据库挂载到特定状态并分析trace日志来定位问题。最终，通过重建控制文件成功解决了错误。文章提供了详细的步骤和SQL命令，供读者参考。
问题：
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [196495], [39399], [39460], [], [], [], [], [], [], []
导致原因：可能是由于服务器宕机，控制文件的缺失，或者在线日志文件在实例恢复时不完整
1、数据库未归档，未备份，没法rman还原
2、数据库可以起到mount状态
3、trace日志 alert_orcl.log日志
根据日志找到 orcl_ora_7268.trc文件日志
Trace file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_7268.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 24 - type 8664, 12 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:14226M/16354M, Ph+PgF:26550M/32707M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 21
Windows thread id: 7268, image: ORACLE.EXE (SHAD)
*** 2022-12-28 20:49:48.722
*** SESSION ID:(1072.34821) 2022-12-28 20:49:48.722
*** CLIENT ID:() 2022-12-28 20:49:48.722
*** SERVICE NAME:() 2022-12-28 20:49:48.722
*** MODULE NAME:(sqlplus.exe) 2022-12-28 20:49:48.722
*** ACTION NAME:() 2022-12-28 20:49:48.722
2022-12-28 20:49:48.707: [ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 2
2022-12-28 20:49:48.722: [ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 2
*** 2022-12-28 20:50:22.590
Successfully allocated 23 recovery slaves
Using 7 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 196495, block 2, scn 21013327794
cache-low rba: logseq 196495, block 29949
on-disk rba: logseq 196495, block 39460, scn 21014230409
start recovery at logseq 196495, block 29949, scn 0
*** 2022-12-28 20:50:22.949
Started writing zeroblks thread 1 seq 196495 blocks 39399-39406
*** 2022-12-28 20:50:22.949
Completed writing zeroblks thread 1 seq 196495
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 8192Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 4725Kb in 0.14s => 32.96 Mb/sec
Longest record: 8Kb, moves: 0/8541 (0%)
最低0.47元/天 解锁文章
3551
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
