Oracle ORA-600[4147]

ORA-600[4147][a][b] it’s a corruption in the undo segment.

Block not new enough (Undo) Sequences match but count wrong.

[a] Record number from the UBA we want to look at.

[b] Count on the Undo block header.

This error is raised when we are looking at a data block, and need to read the undo pointed at by the UBA(eg. for CR) but the record number from the UBA we want to look at doesn’t exist in the

undo block header.

The UNDO block we are looking at is dumped to the trace file before the ORA-600[4147] and call stack.

E.g. in 10.1.0.5

The undo record shows:

2007-07-10 10:48:48.467

*** SERVICE NAME:(SYS$USERS) 2007-07-10 10:48:48.466

*** SESSION ID:(281.26013) 2007-07-10 10:48:48.466

Dump of buffer cache at level 3

BH (0x0x72fcbfe0) file#: 2 rdba: 0x00802fdc (2/12252) class: 42 ba: 0x0x72618000

set: 6 blksize: 8192 bsi: 0 set_flg: 0 pwbcnt: 0

dbwrid: 0 obj: -1 objn: 0 tsn: 1 afn: 2

hash: [53faf870,ac20da50] lru: [53fd885c,57fb57ec]

ckptq: [60fe6408,53fd8830] fileq: [77fed448,68fe2cf0]

use: [NULL] wait: [NULL]

st: XCURRENT md: NULL tch: 2 txn: 0xac793324

flags 0x2002009: buffer_dirty private gotten_in_current_mode redo_since_read

LRBA: [0xba99.1bd30.0] HSCN: [0x0.132c41a1] HSUB: [1]

buffer tsn: 1 rdba: 0x00802fdc (2/12252)

scn: 0x0000.132c41a1 seq: 0x06 flg: 0x00 tail: 0x41a10206

frmt: 0x02 chkval: 0x0000 type: 0x02=KTU UNDO BLOCK

********************************************************************************

UNDO BLK:

xid: 0x000d.024.00004a96 seq: 0x13ae cnt: 0xa irb: 0xa icl: 0x0 flg: 0x0000 --> cnt: 0xa = 10