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

原创

wx6323d657ef2b3 2022-09-16 10:00:17 博主文章分类：Oracle日常管理 ©著作权

©著作权归作者所有：来自51CTO博客作者wx6323d657ef2b3的原创作品，请联系作者获取转载授权，否则将追究法律责任

ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [3313], [2328320], [2334233], [], [], [], [], [], [], []，这里面的最后两个参数的含义是什么？
这里的nab就是Next Available Block number in the Online Redo Log，也就是上述倒数第二个参数2328320。
这里的odr就是On Disk Rba中的block number，也就是上述倒数第一个参数2334233。
kcratr我猜是Kernel Cache Redo Application Transaction Recovery.要注意的是，如果nab小于on disk rba，这一定是不正常的！正常情况下不可能这样。
我们来看一个正常的例子：
online redo log header dump的内容：
DUMP OF LOG FILES: 3 logs in database
LOG FILE #1:
(name #3) /dras20/testdb/redo01.log
Thread 1 redo log links: forward: 2 backward: 0
siz: 0x32000 seq: 0x00000007 hws: 0xb bsz: 512 nab: 0x112 flg: 0x1 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000e88e1
Low scn: 0x0000.000ed77f 12/06/2010 14:15:37
Next scn: 0x0000.40000001 12/06/2010 14:28:17
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=2489685178=0x946594ba, Db Name='TESTDB'
Activation ID=2511161407=0x95ad483f
Control Seq=1533=0x5fd, File size=204800=0x32000
File Number=1, Blksiz=512, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000000007, SCN 0x0000000ed77f-0x000040000001"
thread: 1 nab: 0x112 seq: 0x00000007 hws: 0xb eot: 0 dis: 0
reset logs count: 0x2b616ad3 scn: 0x0000.000a5042
Low scn: 0x0000.000ed77f 12/06/2010 14:15:37
Next scn: 0x0000.40000001 12/06/2010 14:28:17
Enabled scn: 0x0000.000a5042 08/23/2010 15:57:07
Thread closed scn: 0x0000.000f2633 12/06/2010 14:24:59
Log format vsn: 0x8000000 Disk cksum: 0xdf7f Calc cksum: 0xdf7f
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
Miscellaneous flags: 0x0
LOG FILE #2:
(name #2) /dras20/testdb/redo02.log
Thread 1 redo log links: forward: 3 backward: 1
siz: 0x32000 seq: 0x00000008 hws: 0xb bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000ed77f
Low scn: 0x0000.40000001 12/06/2010 14:28:17
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=2489685178=0x946594ba, Db Name='TESTDB'
Activation ID=2511161407=0x95ad483f
Control Seq=1533=0x5fd, File size=204800=0x32000
File Number=2, Blksiz=512, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000000008, SCN 0x000040000001-0xffffffffffff"
thread: 1 nab: 0xffffffff seq: 0x00000008 hws: 0xb eot: 1 dis: 0
reset logs count: 0x2b616ad3 scn: 0x0000.000a5042
Low scn: 0x0000.40000001 12/06/2010 14:28:17
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
Enabled scn: 0x0000.000a5042 08/23/2010 15:57:07
Thread closed scn: 0x0000.4000018d 12/06/2010 15:20:48
Log format vsn: 0x8000000 Disk cksum: 0xa549 Calc cksum: 0xa549
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
Miscellaneous flags: 0x0
LOG FILE #3:
(name #1) /dras20/testdb/redo03.log
Thread 1 redo log links: forward: 0 backward: 2
siz: 0x32000 seq: 0x00000006 hws: 0xd bsz: 512 nab: 0x109 flg: 0x1 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000dd7b8
Low scn: 0x0000.000e88e1 12/06/2010 14:00:52
Next scn: 0x0000.000ed77f 12/06/2010 14:15:37
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=2489685178=0x946594ba, Db Name='TESTDB'
Activation ID=2511161407=0x95ad483f
Control Seq=1533=0x5fd, File size=204800=0x32000
File Number=3, Blksiz=512, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000000006, SCN 0x0000000e88e1-0x0000000ed77f"
thread: 1 nab: 0x109 seq: 0x00000006 hws: 0xd eot: 0 dis: 0
reset logs count: 0x2b616ad3 scn: 0x0000.000a5042
Low scn: 0x0000.000e88e1 12/06/2010 14:00:52
Next scn: 0x0000.000ed77f 12/06/2010 14:15:37
Enabled scn: 0x0000.000a5042 08/23/2010 15:57:07
Thread closed scn: 0x0000.000ed77e 12/06/2010 14:09:52
Log format vsn: 0x8000000 Disk cksum: 0xecd3 Calc cksum: 0xecd3
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
Miscellaneous flags: 0x0
相关的control文件中checkpoint progress区域的内容：
**************************************************************************
CHECKPOINT PROGRESS RECORDS
***************************************************************************
(blkno = 0x4, size = 228, max = 1, in-use = 1, last-recid= 0)
THREAD #1 - status:0x2 flags:0x0 dirty:3849
low cache rba:(0x8.41b.0) on disk rba:(0x8.ec5f.0)
on disk scn: 0x0000.400003f1 12/06/2010 17:01:19
resetlogs scn: 0x0000.000a5042 08/23/2010 15:57:07
heartbeat: 737052598 mount id: 2520411180
MTTR statistics status: 3
Init time: Avg: 5863660, Times measured: 3
File open time: Avg: 2303, Times measured: 28
Log block read time: Avg: 19, Times measured: 3585
Data block handling time: Avg: 885, Times measured: 91
shutdown abort，接着启库后alert log中的内容：
Completed: ALTER DATABASE MOUNT
Mon Dec 6 17:10:05 2010
alter database open
Mon Dec 6 17:10:05 2010
Beginning crash recovery of 1 threads
Mon Dec 6 17:10:05 2010
Started redo scan
Mon Dec 6 17:10:06 2010
Completed redo scan
59460 redo blocks read, 3849 data blocks need recovery
Mon Dec 6 17:10:06 2010
Started recovery at
Thread 1: logseq 8, block 1051, scn 0.0
Mon Dec 6 17:10:07 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 8 Reading mem 0
Mem# 0 errs 0: /dras20/testdb/redo02.log
Mon Dec 6 17:10:07 2010
Completed redo application
Mon Dec 6 17:10:07 2010
Ended recovery at
Thread 1: logseq 8, block 60511, scn 0.1073762833
3849 data blocks read, 3849 data blocks written, 59460 redo blocks read
Crash recovery completed successfully
Mon Dec 6 17:10:07 2010
......省略显示部分内容
SMON: Parallel transaction recovery tried
Mon Dec 6 17:10:09 2010
Completed: alter database open
SQL> select to_char(1051,'XXXX') from dual;
TO_CHAR(1051,'XXXX')
--------------------
41B
SQL> select to_char(60511,'XXXX') from dual;
TO_CHAR(60511,'XXXX')
---------------------
EC5F
这里的含义是一清二楚的，所以我说nab小于on disk rba这一定是不正常的，正常情况下on disk rba一定是小于等于nab的。
这里用到的dump 语句为：
Control file dump
alter session set events 'immediate trace name controlf level 10';
10g里不要用level 10的control file dump
Redo log header dump
alter session set events 'immediate trace name redohdr level 10';