Obtain ROWID from redo log (again)

From: Bart Heinsius <eombah_at_hotmail.com>
Date: 28 May 2002 04:51:12 -0700
Message-ID: <f611b2fd.0205280351.34891765@posting.google.com>

Hi,

Thanks to an earlier reply in this group, I can now find the block and file number from the DBA in the redo log.

Can anyone tell me where the row number is listed so that I can compose the rowid?

REDO RECORD - Thread:1 RBA: 0x099d05.00000003.0010 LEN: 0x019f VLD: 0x01
CONTINUE SCN scn: 0x01c0.7290d20d 04/05/02 20:33:29 CHANGE #1 CLASS: 7 DBA: 0x01000002 INC: 0x00000001 SEQ: 0x0000a38c OPCODE 5.2

ktudh redo: slt: 0x002d sqn: 0x00000092 flg: 0x0012 siz: 175 fbi: 0
            uba: 0x01000300.0043.1a
CHANGE #2 CLASS:  8 DBA: 0x01000300 INC: 0x000019a1 SEQ: 0x0000001a

OPCODE 5.1

ktudb redo: siz: 175 spc: 3795 flg: 0x0012 seq: 0x0043 rec: 0x1a
            xid: 0x0000.02d.00000092
ktubl redo: slt: 45 rci: 0 opc: 11.1 obj: 14 tsn: 0
            dba: 0x00000000 prev ctl uba: 0x01000300.0043.19

prev ctl max cmt scn: 0x0000.4390cd09 prev tx cmt scn: 0x0000.4390cd0a KDO undo record:
KTB Redo, op: L itl: xid: 0x0000.02b.00000092 uba: 0x01000300.0043.19

                      flg: C---    lkc:  0     scn: 0x01c0.727a7c29

KDO Op code: URP xtype: XA bdba: 0x01000035 hdba: 0x01000034

itli: 1  ispac: 0  maxfr: 4863
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 0
ncol: 11 nnew: 10 size: 0

col 1: [ 6] 52 53 5f 31 5f 31
col 2: [ 1] 80

Thanks already,
Bart Received on Tue May 28 2002 - 06:51:12 CDT