-bash-3.00$ ./logdump Oracle GoldenGate Log File Dump Utility for Oracle Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230 Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved. Logdump 71 >open ./dirdat/rm000018 Current LogTrail is /home/ggs/ggs_home/dirdat/rm000018 Logdump 72 >ghdr on Logdump 73 >detail on Logdump 74 >detail data Logdump 75 >usertoken on Logdump 84 >FILTER include filename ROGER.T; Logdump 85 >next ___________________________________________________________________ Hdr-Ind : E (x45) Partition : . (x04) UndoFlag : . (x00) BeforeAfter: B (x42) RecLength : 200 (x00c8) IO Time : 2012/08/31 07:35:43.060.853 IOType : 3 (x03) OrigNode : 255 (xff) TransInd : . (x00) FormatType : R (x52) SyskeyLen : 0 (x00) Incomplete : . (x00) AuditRBA : 8 AuditPos : 19677200 Continued : N (x00) RecCount : 1 (x01) 2012/08/31 07:35:43.060.853 Delete Len 200 RBA 37501 Name: ROGER.T Before Image: Partition 4 G b 0000 000a 0000 0006 5055 424c 4943 0001 0016 0000 | ........PUBLIC...... 0012 4756 2444 425f 4341 4348 455f 4144 5649 4345 | ..GV$DB_CACHE_ADVICE 0002 0004 ffff 0000 0003 0008 0000 0004 3230 3437 | ................2047 0004 0004 ffff 0000 0005 000b 0000 0007 5359 4e4f | ................SYNO 4e59 4d00 0600 1500 0032 3030 352d 3036 2d33 303a | NYM......2005-06-30: 3139 3a31 313a 3034 0007 0015 0000 3230 3035 2d30 | 19:11:04......2005-0 362d 3330 3a31 393a 3131 3a30 3400 0800 1700 0000 | 6-30:19:11:04....... Column 0 (x0000), Len 10 (x000a) 0000 0006 5055 424c 4943 | ....PUBLIC Column 1 (x0001), Len 22 (x0016) 0000 0012 4756 2444 425f 4341 4348 455f 4144 5649 | ....GV$DB_CACHE_ADVI 4345 | CE Column 2 (x0002), Len 4 (x0004) ffff 0000 | .... Column 3 (x0003), Len 8 (x0008) 0000 0004 3230 3437 | ....2047 Column 4 (x0004), Len 4 (x0004) ffff 0000 | .... Column 5 (x0005), Len 11 (x000b) 0000 0007 5359 4e4f 4e59 4d | ....SYNONYM Column 6 (x0006), Len 21 (x0015) 0000 3230 3035 2d30 362d 3330 3a31 393a 3131 3a30 | ..2005-06-30:19:11:0 34 | 4 Column 7 (x0007), Len 21 (x0015) 0000 3230 3035 2d30 362d 3330 3a31 393a 3131 3a30 | ..2005-06-30:19:11:0 34 | 4 Column 8 (x0008), Len 23 (x0017) 0000 0013 3230 3035 2d30 362d 3330 3a31 393a 3131 | ....2005-06-30:19:11 3a30 34 | :04 Column 9 (x0009), Len 9 (x0009) 0000 0005 5641 4c49 44 | ....VALID Column 10 (x000a), Len 5 (x0005) 0000 0001 4e | ....N Column 11 (x000b), Len 5 (x0005) 0000 0001 4e | ....N Column 12 (x000c), Len 5 (x0005) 0000 0001 4e | ....N Filtering suppressed 161 records Logdump 86 >n ___________________________________________________________________ Hdr-Ind : E (x45) Partition : . (x04) UndoFlag : . (x00) BeforeAfter: B (x42) RecLength : 197 (x00c5) IO Time : 2012/08/31 07:35:43.060.853 IOType : 3 (x03) OrigNode : 255 (xff) TransInd : . (x01) FormatType : R (x52) SyskeyLen : 0 (x00) Incomplete : . (x00) AuditRBA : 8 AuditPos : 19677888 Continued : N (x00) RecCount : 1 (x01) 2012/08/31 07:35:43.060.853 Delete Len 197 RBA 37810 Name: ROGER.T Before Image: Partition 4 G m 0000 0007 0000 0003 5359 5300 0100 1900 0000 1547 | ........SYS........G 565f 2453 4741 5f54 4152 4745 545f 4144 5649 4345 | V_$SGA_TARGET_ADVICE 0002 0004 ffff 0000 0003 0008 0000 0004 3230 3438 | ................2048 0004 0004 ffff 0000 0005 0008 0000 0004 5649 4557 | ................VIEW 0006 0015 0000 3230 3035 2d30 362d 3330 3a31 393a | ......2005-06-30:19: 3131 3a30 3400 0700 1500 0032 3030 352d 3036 2d33 | 11:04......2005-06-3 303a 3139 3a31 313a 3034 0008 0017 0000 0013 3230 | 0:19:11:04........20 Column 0 (x0000), Len 7 (x0007) 0000 0003 5359 53 | ....SYS Column 1 (x0001), Len 25 (x0019) 0000 0015 4756 5f24 5347 415f 5441 5247 4554 5f41 | ....GV_$SGA_TARGET_A 4456 4943 45 | DVICE Column 2 (x0002), Len 4 (x0004) ffff 0000 | .... Column 3 (x0003), Len 8 (x0008) 0000 0004 3230 3438 | ....2048 Column 4 (x0004), Len 4 (x0004) ffff 0000 | .... Column 5 (x0005), Len 8 (x0008) 0000 0004 5649 4557 | ....VIEW Column 6 (x0006), Len 21 (x0015) 0000 3230 3035 2d30 362d 3330 3a31 393a 3131 3a30 | ..2005-06-30:19:11:0 34 | 4 Column 7 (x0007), Len 21 (x0015) 0000 3230 3035 2d30 362d 3330 3a31 393a 3131 3a30 | ..2005-06-30:19:11:0 34 | 4 Column 8 (x0008), Len 23 (x0017) 0000 0013 3230 3035 2d30 362d 3330 3a31 393a 3131 | ....2005-06-30:19:11 3a30 34 | :04 Column 9 (x0009), Len 9 (x0009) 0000 0005 5641 4c49 44 | ....VALID Column 10 (x000a), Len 5 (x0005) 0000 0001 4e | ....N Column 11 (x000b), Len 5 (x0005) 0000 0001 4e | ....N Column 12 (x000c), Len 5 (x0005) 0000 0001 4e | ....N Logdump 87 > Logdump 87 >n ___________________________________________________________________ Hdr-Ind : E (x45) Partition : . (x04) UndoFlag : . (x00) BeforeAfter: B (x42) RecLength : 202 (x00ca) IO Time : 2012/08/31 07:35:43.060.853 IOType : 3 (x03) OrigNode : 255 (xff) TransInd : . (x01) FormatType : R (x52) SyskeyLen : 0 (x00) Incomplete : . (x00) AuditRBA : 8 AuditPos : 19678284 Continued : N (x00) RecCount : 1 (x01) 2012/08/31 07:35:43.060.853 Delete Len 202 RBA 38093 Name: ROGER.T Before Image: Partition 4 G m 0000 000a 0000 0006 5055 424c 4943 0001 0018 0000 | ........PUBLIC...... 0014 4756 2453 4741 5f54 4152 4745 545f 4144 5649 | ..GV$SGA_TARGET_ADVI 4345 0002 0004 ffff 0000 0003 0008 0000 0004 3230 | CE................20 3439 0004 0004 ffff 0000 0005 000b 0000 0007 5359 | 49................SY 4e4f 4e59 4d00 0600 1500 0032 3030 352d 3036 2d33 | NONYM......2005-06-3 303a 3139 3a31 313a 3034 0007 0015 0000 3230 3035 | 0:19:11:04......2005 2d30 362d 3330 3a31 393a 3131 3a30 3400 0800 1700 | -06-30:19:11:04..... Column 0 (x0000), Len 10 (x000a) 0000 0006 5055 424c 4943 | ....PUBLIC Column 1 (x0001), Len 24 (x0018) 0000 0014 4756 2453 4741 5f54 4152 4745 545f 4144 | ....GV$SGA_TARGET_AD 5649 4345 | VICE Column 2 (x0002), Len 4 (x0004) ffff 0000 | .... Column 3 (x0003), Len 8 (x0008) 0000 0004 3230 3439 | ....2049 Column 4 (x0004), Len 4 (x0004) ffff 0000 | .... Column 5 (x0005), Len 11 (x000b) 0000 0007 5359 4e4f 4e59 4d | ....SYNONYM Column 6 (x0006), Len 21 (x0015) 0000 3230 3035 2d30 362d 3330 3a31 393a 3131 3a30 | ..2005-06-30:19:11:0 34 | 4 Column 7 (x0007), Len 21 (x0015) 0000 3230 3035 2d30 362d 3330 3a31 393a 3131 3a30 | ..2005-06-30:19:11:0 34 | 4 Column 8 (x0008), Len 23 (x0017) 0000 0013 3230 3035 2d30 362d 3330 3a31 393a 3131 | ....2005-06-30:19:11 3a30 34 | :04 Column 9 (x0009), Len 9 (x0009) 0000 0005 5641 4c49 44 | ....VALID Column 10 (x000a), Len 5 (x0005) 0000 0001 4e | ....N Column 11 (x000b), Len 5 (x0005) 0000 0001 4e | ....N Column 12 (x000c), Len 5 (x0005) 0000 0001 4e | ....N Logdump 88 >n ___________________________________________________________________ Hdr-Ind : E (x45) Partition : . (x04) UndoFlag : . (x00) BeforeAfter: B (x42) RecLength : 198 (x00c6) IO Time : 2012/08/31 07:35:43.060.853 IOType : 3 (x03) OrigNode : 255 (xff) TransInd : . (x01) FormatType : R (x52) SyskeyLen : 0 (x00) Incomplete : . (x00) AuditRBA : 8 AuditPos : 19678668 Continued : N (x00) RecCount : 1 (x01) 2012/08/31 07:35:43.060.853 Delete Len 198 RBA 38381 Name: ROGER.T Before Image: Partition 4 G m 0000 0007 0000 0003 5359 5300 0100 1a00 0000 1647 | ........SYS........G 565f 2453 4547 4d45 4e54 5f53 5441 5449 5354 4943 | V_$SEGMENT_STATISTIC 5300 0200 04ff ff00 0000 0300 0800 0000 0432 3035 | S................205 3000 0400 04ff ff00 0000 0500 0800 0000 0456 4945 | 0................VIE 5700 0600 1500 0032 3030 352d 3036 2d33 303a 3139 | W......2005-06-30:19 3a31 313a 3034 0007 0015 0000 3230 3035 2d30 362d | :11:04......2005-06- 3330 3a31 393a 3131 3a30 3400 0800 1700 0000 1332 | 30:19:11:04........2 Column 0 (x0000), Len 7 (x0007) 0000 0003 5359 53 | ....SYS Column 1 (x0001), Len 26 (x001a) 0000 0016 4756 5f24 5345 474d 454e 545f 5354 4154 | ....GV_$SEGMENT_STAT 4953 5449 4353 | ISTICS Column 2 (x0002), Len 4 (x0004) ffff 0000 | .... Column 3 (x0003), Len 8 (x0008) 0000 0004 3230 3530 | ....2050 Column 4 (x0004), Len 4 (x0004) ffff 0000 | .... Column 5 (x0005), Len 8 (x0008) 0000 0004 5649 4557 | ....VIEW Column 6 (x0006), Len 21 (x0015) 0000 3230 3035 2d30 362d 3330 3a31 393a 3131 3a30 | ..2005-06-30:19:11:0 34 | 4 Column 7 (x0007), Len 21 (x0015) 0000 3230 3035 2d30 362d 3330 3a31 393a 3131 3a30 | ..2005-06-30:19:11:0 34 | 4 Column 8 (x0008), Len 23 (x0017) 0000 0013 3230 3035 2d30 362d 3330 3a31 393a 3131 | ....2005-06-30:19:11 3a30 34 | :04 Column 9 (x0009), Len 9 (x0009) 0000 0005 5641 4c49 44 | ....VALID Column 10 (x000a), Len 5 (x0005) 0000 0001 4e | ....N Column 11 (x000b), Len 5 (x0005) 0000 0001 4e | ....N Column 12 (x000c), Len 5 (x0005) 0000 0001 4e | ....N