RE: alter system dump logfile ... question

[Goulet, Dick]

Title: alter system dump logfile ... question

I believe you'll need to use LogMiner.

 

Dick Goulet

-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
Subject: alter system dump logfile ... question

I am trying to find who deleted certain rows fro a table. So I dumped the right logfile with 'layer 11 opcode 3' option. I can see the information about deleted rows, but where is it stored .. whodunit??

Here is a partial listing ... the objectid is 29230 as seen from objn value
--------------------------------------------------------------------------------
REDO RECORD - Thread:1 RBA: 0x0013de.0004a4d4.0088 LEN: 0x0118 VLD: 0x01
SCN: 0x0010.61152c4f SUBSCN:  1 03/25/2003 11:59:02
CHANGE #1 TYP:0 CLS:74 AFN:2 DBA:0x0080671f SCN:0x0010.61152c4f SEQ:  1 OP:5.1
ktudb redo: siz: 156 spc: 4728 flg: 0x0022 seq: 0x093e rec: 0x22
            xid:  0x001d.016.00003c57 
ktubu redo: slt: 22 rci: 33 opc: 11.1 objn: 29230 objd: 29230 tsn: 31
Undo type:  Regular undo       Undo type:  Last buffer split:  No
Tablespace Undo:  No
             0x00000000
KDO undo record:
KTB Redo
op: 0x02  ver: 0x01 
op: C  uba: 0x0080671f.093e.1c
KDO Op code: IRP row dependencies Disabled
  xtype: XA  bdba: 0x07d05920  hdba: 0x07d0590c
itli: 1  ispac: 0  maxfr: 4858
tabn: 0 slot: 3(0x3) size/delt: 44
fb: --H-FL-- lb: 0x1  cc: 5
null: -----
col  0: [10]  61 62 63 5f 66 61 6d 5f 6c 61
col  1: [10]  41 42 43 20 46 61 6d 69 6c 79
col  2: [ 4]  48 50 49 56
col  3: [ 1]  4c
col  4: [11]  4c 6f 73 20 41 6e 67 65 6c 65 73
CHANGE #2 TYP:0 CLS: 1 AFN:31 DBA:0x07d05920 SCN:0x0010.6115216c SEQ:  1 OP:11.3
KTB Redo
op: 0x02  ver: 0x01 
op: C  uba: 0x0080671f.093e.22
KDO Op code: DRP row dependencies Disabled
  xtype: XA  bdba: 0x07d05920  hdba: 0x07d0590c
itli: 1  ispac: 0  maxfr: 4858
tabn: 0 slot: 3(0x3)
--------------------------------------------------------------------------------

I want to see if I can decode it from the dump, logminer is my last resort. I could learn some more from decoding the dump too.

Thanks in advance
Raj
-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!