Re: Obtaining ROWID from redo log record

You can find the block from the dba (there is a package in DBMS_UTILITY called something similar to
convert dba to file# and block#). Once you get the file # and block # , you can easily find the
record and rowid..

I am not playing much with redo dumps these days. Perhaps some one will give you a direct
solution.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

"Bart Heinsius" <eombah_at_hotmail.com> wrote in message news:f611b2fd.0205220207.17e51532_at_posting.google.com...
> Hi,
>
> I'm an Oracle novice so please excuse any dumb questions I may ask.
> My site is running 7.3.3.6.0.
>
> Can anyone help me with obtaining the rowid of the record that was
updated?
> The redo log contains:
>
> CHANGE #3 CLASS: 1 DBA: 0x01000035 INC: 0x00000811 SEQ: 0x00004a78 OPCODE
11.5
> KTB Redo, op: F xid: 0x0000.02a.00000092 uba: 0x01000300.0043.1b
> Block cleanout record, scn: 0x01c0.7290d20e, entries follow...
> itli: 1 flg: 2 scn: 0x01c0.7290d20e
> KDO Op code: URP xtype: XA bdba: 0x01000035 hdba: 0x01000034
> itli: 1 ispac: 0 maxfr: 4863
> tabn: 0 slot: 3(0x3) flag: 0x2c lock: 1 ckix: 0
> ncol: 11 nnew: 10 size: 0
> col 1: [ 6] 52 53 5f 31 5f 32
> col 2: [ 1] 80
> col 3: [ 2] c1 03
> col 4: [ 3] c2 5a 3f
> col 5: [ 6] c5 14 17 0a 24 4d
> col 6: [ 3] c2 05 31
> col 7: [ 4] c3 54 0d 5b
> col 8: [ 4] c3 02 3a 40
> col 9: [ 1] 80
> col 10: [ 2] c1 03
>
> Thanks already,
> Bart
Received on Wed May 22 2002 - 06:32:41 CDT