Thanks Dennis,
That's what I am trying to find ... which column to match ... and yes in past I have used logminer with a lot of success ...
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 !!
-----Original Message-----
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 26, 2003 2:09 PM
To: '[EMAIL PROTECTED]'
Cc: Jamadagni, Rajendra
Subject: RE: alter system dump logfile ... question
Raj
I haven't tried reading logs without Logminer, but I have used Logminer
without the dictionary. It is tough. Basically, everything is in hex. I
would guess the "who" is the userid in hex. You could list the usernames and
user_ids from dba_users and convert the user_id column to hex and see if a
value matches.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 26, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: alter system dump logfile ... question
Dick,
I tried various methods ... v$logmnr_contents has 0 rows ... that's why the
hard way of doing things ... as usual metablink is little low of details
about v$logmnr_contents containing no rows.
Egads ... I am finally back on the list after 03/18 ... thanks to our
resident investigator Bruce (the list master) ...
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 !!
-----Original Message-----
From: Goulet, Dick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 26, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 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 !!
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
