1 Reply Latest reply: Mar 28, 2013 7:36 AM by Raj.Ogg-Oracle RSS

    LOGDUMP utility, more than one filter at a time

    leighannedowns
      I need to search in a trailfile for a specific transaction and would like to search for an update statement to table XYZ. When I issue the following commands, it only uses the filter for the update statement:

      Logdump 115 >filter clear
      Logdump 116 >open ./dirdat/XY000009
      Current LogTrail is
      Logdump 117 >detail on
      Logdump 118 >ghdr on
      Logdump 119 >filter include filename CORRECT.XYZ
      Logdump 120 >filter include iotype FieldComp
      Logdump 121 >n
      ___________________________________________________________________
      Hdr-Ind : E (x45) Partition : . (x04)
      UndoFlag : . (x00) BeforeAfter: A (x41)
      RecLength : 92 (x005c) IO Time : 2013/03/26 17:12:48.000.000
      IOType : 15 (x0f) OrigNode : 255 (xff)
      TransInd : . (x02) FormatType : R (x52)
      SyskeyLen : 0 (x00) Incomplete : . (x00)
      AuditRBA : 76 AuditPos : 131521360
      Continued : N (x00) RecCount : 1 (x01)

      2013/03/26 17:12:48.000.000 FieldComp Len 92 RBA 11416
      Name: WRONG.TABLE_NAME
      After Image: Partition 4 G e
      0000 000a 0000 0000 0000 0001 e6ce 0001 000a 0000 | ....................
      0000 0000 0000 0004 0005 0015 0000 3230 3133 2d30 | ..............2013-0
      332d 3236 3a31 373a 3132 3a34 3800 0700 0a00 0000 | 3-26:17:12:48.......
      0000 0000 0000 2700 0a00 1500 0032 3031 332d 3033 | ......'......2013-03
      2d32 363a 3137 3a31 323a 3438 | -26:17:12:48
      Column 0 (x0000), Len 10 (x000a)
      Column 1 (x0001), Len 10 (x000a)
      Column 5 (x0005), Len 21 (x0015)
      Column 7 (x0007), Len 10 (x000a)
      Column 10 (x000a), Len 21 (x0015)


      Filtering suppressed 32 records