日期:2014-05-16  浏览次数:20439 次

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

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,