=====================
General
=====================
Read Golden gate dirdat file by example using logdump utility
Read Golden gate dirdat file by example using logdump utility
Run logdump utility
oracle@my_server:/software/ogg/191>% ./logdump
Oracle GoldenGate Log File Dump Utility for Oracle
Version 19.1.0.0.1 OGGCORE_19.1.0.0.0_PLATFORMS_190524.2201
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
2022-09-08 05:25:11 WARNING OGG-10173 (GLOBALS) line 3: Parsing error, [SYSLOG] is deprecated.
Open a file
Logdump 25 >open /software/ogg/191/dirdat/01/out/ei000000547
Current LogTrail is /software/ogg/191/dirdat/01/out/ei000000547
Set display details on
Logdump 26 >ghdr on
Logdump 27 >detail on
Logdump 32 >fileheader on
Logdump 34 >detail data
Read next record. It would be File Header
Logdump 36 >n
2022/09/08 02:11:48.956.534 FileHeader Len 1779 RBA 0
Name: *FileHeader*
3000 0343 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0..C0...GG..TL..1...
0007 3200 0004 2000 0000 3300 0008 02f3 0e54 6873 | ..2... ...3......Ths
0976 3400 002e 002c 7572 693a 4445 5241 5456 4442 | .v4....,uri:DERATVDB
3030 3030 313a 3a73 6f66 7477 6172 653a 6f67 673a | 00001::software:ogg:
3139 313a 4558 545f 495f 3031 3600 002d 002b 2f73 | 191:EXT_I_016..-.+/s
6f66 7477 6172 652f 6f67 672f 3139 312f 6469 7264 | oftware/ogg/191/dird
6174 2f30 312f 6f75 742f 6569 3030 3030 3030 3534 | at/01/out/ei00000054
GroupID x30 '0' TrailInfo Info x00 Length 835
3000 0343 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0..C0...GG..TL..1...
0007 3200 0004 2000 0000 3300 0008 02f3 0e54 6873 | ..2... ...3......Ths
0976 3400 002e 002c 7572 693a 4445 5241 5456 4442 | .v4....,uri:DERATVDB
3030 3030 313a 3a73 6f66 7477 6172 653a 6f67 673a | 00001::software:ogg:
3139 313a 4558 545f 495f 3031 3600 002d 002b 2f73 | 191:EXT_I_016..-.+/s
6f66 7477 6172 652f 6f67 672f 3139 312f 6469 7264 | oftware/ogg/191/dird
6174 2f30 312f 6f75 742f 6569 3030 3030 3030 3534 | at/01/out/ei00000054
3737 0000 0101 3800 0004 0000 0223 3900 0008 0000 | 77....8......#9.....
0000 1dcd 5e90 3a00 0081 0b32 3537 3735 3635 3835 | ....^.:....257756585
3437 0000 0000 0000 0000 0000 0000 0000 0000 0000 | 47..................
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 | ....................
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 | ....................
GroupID x32 '2' DatabaseInfo Info x00 Length 358
3200 0166 3000 0002 0007 3100 0005 0003 4947 5432 | 2..f0.....1.....IGT2
0000 0500 0369 6774 3300 0004 0000 0000 3400 0002 | .....igt3.......4...
000c 3500 0002 0002 3600 00e7 00e5 4f72 6163 6c65 | ..5.....6.....Oracle
2044 6174 6162 6173 6520 3132 6320 456e 7465 7270 | Database 12c Enterp
7269 7365 2045 6469 7469 6f6e 2052 656c 6561 7365 | rise Edition Release
2031 322e 322e 302e 312e 3020 2d20 3634 6269 7420 | 12.2.0.1.0 - 64bit
5072 6f64 7563 7469 6f6e 0a50 4c2f 5351 4c20 5265 | Production.PL/SQL Re
6c65 6173 6520 3132 2e32 2e30 2e31 2e30 202d 2050 | lease 12.2.0.1.0 - P
726f 6475 6374 696f 6e0a 434f 5245 0931 322e 322e | roduction.CORE.12.2.
302e 312e 3009 5072 6f64 7563 7469 6f6e 0a54 4e53 | 0.1.0.Production.TNS
2066 6f72 204c 696e 7578 3a20 5665 7273 696f 6e20 | for Linux: Version
3132 2e32 2e30 2e31 2e30 202d 2050 726f 6475 6374 | 12.2.0.1.0 - Product
696f 6e0a 4e4c 5352 544c 2056 6572 7369 6f6e 2031 | ion.NLSRTL Version 1
322e 322e 302e 312e 3020 2d20 5072 6f64 7563 7469 | 2.2.0.1.0 - Producti
6f6e 0a37 0000 0400 0000 0038 0000 0c00 0a31 322e | on.7.......8.....12.
322e 302e 312e 3039 0000 0400 0000 013a 0000 0200 | 2.0.1.09.......:....
003b 0000 0400 0000 013c 0000 1400 0000 1014 1414 | .;.......<..........
1414 1414 1414 1414 1411 1414 143d 0000 0500 | .............=....
GroupID x33 '3' ProducerInfo Info x00 Length 119
3300 0077 3000 000a 0008 4558 545f 495f 3031 3100 | 3..w0.....EXT_I_011.
0002 0003 3200 0002 0013 3300 0002 0001 3400 0002 | ....2.....3.....4...
0000 3500 0002 0000 3600 0002 0001 3700 0041 003f | ..5.....6.....7..A.?
5665 7273 696f 6e20 3139 2e31 2e30 2e30 2e31 204f | Version 19.1.0.0.1 O
4747 434f 5245 5f31 392e 312e 302e 302e 305f 504c | GGCORE_19.1.0.0.0_PL
4154 464f 524d 535f 3139 3035 3234 2e32 3230 31 | ATFORMS_190524.2201
Read next record. It would be File Metadata
Logdump 37 >n
2022/09/04 12:10:00.319.559 Metadata Len 78 RBA 1787
Database Name:
*
DDR Version: 1
Database type: ORACLE
Character set ID: UTF-8
National character set ID: UTF-16
Locale: neutral
Case sensitivity: 14 14 14 14 14 14 14 14 14 14 14 14 11 14 14 14
TimeZone: GMT
Global name: IGT
*
Read next record. It would be Record Metadata
Logdump 38 >n
2022/09/04 14:57:26.998.524 Metadata Len 10069 RBA 1916
Table Name: MY_SCHEMA.SFI_CUSTOMER_PROFILE
*
1)Name 2)Data Type 3)External Length 4)Fetch Offset 5)Scale 6)Level
7)Null 8)Bump if Odd 9)Internal Length 10)Binary Length 11)Table Length 12)Most Sig DT
13)Least Sig DT 14)High Precision 15)Low Precision 16)Elementary Item 17)Occurs 18)Key Column
19)Sub DataType 20)Native DataType 21)Character Set 22)Character Length 23)LOB Type 24)Partial Type
*
TDR version: 11
Definition for table MY_SCHEMA.SFI_CUSTOMER_PROFILE
Record Length: 68504
Columns: 132
KEY1 64 120 0 0 0 1 0 120 120 0 0 0 0 0 1 0 1 0 1 -1 120 0 0
property: 0x0000000000800000
IMSI 64 120 126 0 0 1 0 120 120 0 0 0 0 0 1 0 0 0 1 -1 120 0 0
property: 0x0000000000800000
ATTR1 64 800 252 0 0 1 0 800 800 0 0 0 0 0 1 0 0 0 1 -1 800 0 0
property: 0x0000000000800000
ATTR2 64 800 1058 0 0 1 0 800 800 0 0 0 0 0 1 0 0 0 1 -1 800 0 0
property: 0x0000000000800000
ATTR3 64 800 1864 0 0 1 0 800 800 0 0 0 0 0 1 0 0 0 1 -1 800 0 0
property: 0x0000000000800000
ATTR4 64 800 2670 0 0 1 0 800 800 0 0 0 0 0 1 0 0 0 1 -1 800 0 0
property: 0x0000000000800000
ATTR5 64 800 3476 0 0 1 0 800 800 0 0 0 0 0 1 0 0 0 1 -1 800 0 0
property: 0x0000000000800000
ATTR6 64 800 4282 0 0 1 0 800 800 0 0 0 0 0 1 0 0 0 1 -1 800 0 0
property: 0x0000000000800000
ATTR7 64 800 5088 0 0 1 0 800 800 0 0 0 0 0 1 0 0 0 1 -1 800 0 0
property: 0x0000000000800000
ATTR8 64 800 5894 0 0 1 0 800 800 0 0 0 0 0 1 0 0 0 1 -1 800 0 0
property: 0x0000000000800000
ATTR9 64 800 6700 0 0 1 0 800 800 0 0 0 0 0 1 0 0 0 1 -1 800 0 0
property: 0x0000000000800000
ATTR10 64 800 7506 0 0 1 0 800 800 0 0 0 0 0 1 0 0 0 1 -1 800 0 0
property: 0x0000000000800000
Read next record. It would be Record data
Logdump 39 >n
2022/09/08 02:11:47.000.000 GGSUnifiedUpdate Len 1687 RBA 12072
Name: MY_SCHEMA.SFI_CUSTOMER_PROFILE (TDR Index: 1)
After Image: Partition x0c G m
d704 0000 0000 0f00 0000 0b00 3936 3837 3732 3436 | ............96877246
3636 3901 0004 00ff ff00 0002 000d 0000 0009 0042 | 669................B
6c75 652d 5041 5947 0300 0b00 0000 0700 7072 6570 | lue-PAYG........prep
6169 6404 000c 0000 0008 0043 6f6e 7375 6d65 7205 | aid........Consumer.
0006 0000 0002 0065 6e06 0004 00ff ff00 0007 0004 | .......en...........
00ff ff00 0008 0004 00ff ff00 0009 0004 00ff ff00 | ....................
000a 0004 00ff ff00 000b 0004 00ff ff00 000c 0004 | ....................
Before Image Len 1243 (x000004db)
BeforeColumnLen 1239 (x000004d7)
Column 0 (x0000), Len 15 (x000f)
0000 0b00 3936 3837 3732 3436 3636 39 | ....96877246669
Column 1 (x0001), Len 4 (x0004)
ffff 0000 | ....
Column 2 (x0002), Len 13 (x000d)
0000 0900 426c 7565 2d50 4159 47 | ....Blue-PAYG
Column 3 (x0003), Len 11 (x000b)
0000 0700 7072 6570 6169 64 | ....prepaid
Column 4 (x0004), Len 12 (x000c)
0000 0800 436f 6e73 756d 6572 | ....Consumer
Column 5 (x0005), Len 6 (x0006)
0000 0200 656e | ....en
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ....
Column 7 (x0007), Len 4 (x0004)
ffff 0000 | ....
Column 8 (x0008), Len 4 (x0004)
ffff 0000 | ....
Column 9 (x0009), Len 4 (x0004)
ffff 0000 | ....
Column 10 (x000a), Len 4 (x0004)
ffff 0000 | ....
After Image Len 444 (x000001bc)
Column 0 (x0000), Len 15 (x000f)
0000 0b00 3936 3837 3732 3436 3636 39 | ....96877246669
Column 2 (x0002), Len 13 (x000d)
0000 0900 426c 7565 2d50 4159 47 | ....Blue-PAYG
Column 3 (x0003), Len 11 (x000b)
0000 0700 7072 6570 6169 64 | ....prepaid
Column 4 (x0004), Len 12 (x000c)
0000 0800 436f 6e73 756d 6572 | ....Consumer
Column 5 (x0005), Len 6 (x0006)
0000 0200 656e | ....en
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ....
Column 7 (x0007), Len 4 (x0004)
ffff 0000 | ....
Column 8 (x0008), Len 4 (x0004)
ffff 0000 | ....
Column 9 (x0009), Len 4 (x0004)
ffff 0000 | ....
Column 10 (x000a), Len 4 (x0004)
ffff 0000
Read next record. It would be another Record data
Logdump 40 >n
2022/09/08 02:11:47.000.000 GGSUnifiedUpdate Len 1679 RBA 13839
Name: MY_SCHEMA.SFI_CUSTOMER_PROFILE (TDR Index: 1)
After Image: Partition x0c G m
d304 0000 0000 0f00 0000 0b00 3936 3837 3732 3436 | ............96877246
3637 3001 0004 00ff ff00 0002 0009 0000 0005 0042 | 670................B
6c61 636b 0300 0b00 0000 0700 7072 6570 6169 6404 | lack........prepaid.
000c 0000 0008 0043 6f6e 7375 6d65 7205 0006 0000 | .......Consumer.....
0002 0065 6e06 0004 00ff ff00 0007 0004 00ff ff00 | ...en...............
0008 0004 00ff ff00 0009 0004 00ff ff00 000a 0004 | ....................
00ff ff00 000b 0004 00ff ff00 000c 0004 00ff ff00 | ....................
Before Image Len 1239 (x000004d7)
BeforeColumnLen 1235 (x000004d3)
Column 0 (x0000), Len 15 (x000f)
0000 0b00 3936 3837 3732 3436 3637 30 | ....96877246670
Column 1 (x0001), Len 4 (x0004)
ffff 0000 | ....
Column 2 (x0002), Len 9 (x0009)
0000 0500 426c 6163 6b | ....Black
Column 3 (x0003), Len 11 (x000b)
0000 0700 7072 6570 6169 64 | ....prepaid
Column 4 (x0004), Len 12 (x000c)
0000 0800 436f 6e73 756d 6572 | ....Consumer
Column 5 (x0005), Len 6 (x0006)
0000 0200 656e | ....en
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ....
Column 7 (x0007), Len 4 (x0004)
ffff 0000 | ....
Column 8 (x0008), Len 4 (x0004)
ffff 0000 | ....
Column 9 (x0009), Len 4 (x0004)
ffff 0000 | ....
Column 10 (x000a), Len 4 (x0004)
ffff 0000 | ....
Logdump 41 >exit
No comments:
Post a Comment