Obtain ROWID from redo log (try again)

From: Bart Heinsius <eombah_at_hotmail.com>
Date: 27 May 2002 06:51:27 -0700
Message-ID: <f611b2fd.0205270551.cf3798d_at_posting.google.com>

Hi,

From the DBA in the redo log I can now find the block and file number. 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 Mon May 27 2002 - 15:51:27 CEST