Logdump 1 >ghdr on
Logdump 2 >detail on
Logdump 3 >detail data
Logdump 4 >open ep000000003
Current LogTrail is /software/ogg/191/dirdat/01/out/ep000000003
Logdump 5 >n
Logdump 6 >n
Logdump 7 >n
...
...
After reading header metadata and some records, one can see the record in question
Logdump 29 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 36 (x0024) IO Time : 2026/01/30 20:29:22.983.254
IOType : 134 (x86) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 18680 AuditPos : 87598608
Continued : N (x00) RecCount : 1 (x01)
2026/01/30 20:29:22.983.254 GGSUnifiedUpdate Len 36 RBA 2571
Name: USER_A.TABLE_A (TDR Index: 1)
After Image: Partition x0c G s
1000 0000 0100 0c00 0000 0800 5465 7374 2031 3031 | ......Test 101
0100 0c00 0000 0800 5465 7374 2031 3032 | ......Test 102
Before Image Len 20 (x00000014)
BeforeColumnLen 16 (x00000010)
Column 1 (x0001), Len 12 (x000c)
0000 0800 5465 7374 2031 3031 | ....Test 101
After Image Len 16 (x00000010)
Column 1 (x0001), Len 12 (x000c)
0000 0800 5465 7374 2031 3032 | ....Test 102
It is possible to view a summary of the report:
./logdump
Logdump 1 > OPEN /software/ogg/191/dirdat/01/in/et000000004
Logdump 2 > GHDR ON
Logdump 3 > DETAIL ON
Logdump 4 > DETAIL DATA
Logdump 5 > LOG TO full_file_dump.txt
Logdump 6 > COUNT
Logdump 7 > LOG STOP
Logdump 8 > EXIT
Example:
./logdump
Logdump 1 > OPEN /software/ogg/191/dirdat/01/in/et000000004
Logdump 2 > GHDR ON
Logdump 3 > DETAIL ON
Logdump 4 > DETAIL DATA
Logdump 5 > LOG TO full_file_dump.txt
Logdump 6 > COUNT
Logdump 7 > LOG STOP
Logdump 8 > EXIT
Logdump 30 >open /software/ogg/191/dirdat/01/in/et000000004
Current LogTrail is /software/ogg/191/dirdat/01/in/et000000004
Logdump 31 >GHDR ON
Logdump 32 >DETAIL ON
Logdump 33 >DETAIL DATA
Logdump 34 >LOG TO /software/ogg/191/dirdat/et000000004_full_dump.txt
--- Session log /software/ogg/191/dirdat/et000000004_full_dump.txt opened 2026/02/01 12:19:24.549.821 ---
Logdump 35 >COUNT
LogTrail /software/ogg/191/dirdat/01/in/et000000004 has 10 records
Total Data Bytes 1866
Avg Bytes/Record 186
Delete 2
Insert 2
Update 1
RestartOK 2
Metadata Records 2
Others 1
Before Images 2
After Images 5
Average of 9 Transactions
Bytes/Trans ..... 101
Records/Trans ... 1
Files/Trans ..... 1
Partition x00
Total Data Bytes 78
Avg Bytes/Record 26
RestartOK 2
Metadata Records 1
After Images 2
*FileHeader* Partition x00
Total Data Bytes 1388
Avg Bytes/Record 1388
Others 1
LAB_QANFV_ALLQQ.ACTION_TYPES Partition x00
Total Data Bytes 244
Avg Bytes/Record 244
Metadata Records 1
LAB_QANFV_ALLQQ.ACTION_TYPES Partition x0c
Total Data Bytes 156
Avg Bytes/Record 31
Delete 2
Insert 2
Update 1
Before Images 2
After Images 3
Logdump 36 >LOG STOP
Logging stopped
Logdump 37 >EXIT
oracle@qanfv-1-dbs-1b:/software/ogg/191>%
Logdump 30 >open /software/ogg/191/dirdat/01/in/et000000004
Current LogTrail is /software/ogg/191/dirdat/01/in/et000000004
Logdump 31 >GHDR ON
Logdump 32 >DETAIL ON
Logdump 33 >DETAIL DATA
Logdump 34 >LOG TO /software/ogg/191/dirdat/et000000004_full_dump.txt
--- Session log /software/ogg/191/dirdat/et000000004_full_dump.txt opened 2026/02/01 12:19:24.549.821 ---
Logdump 35 >COUNT
LogTrail /software/ogg/191/dirdat/01/in/et000000004 has 10 records
Total Data Bytes 1866
Avg Bytes/Record 186
Delete 2
Insert 2
Update 1
RestartOK 2
Metadata Records 2
Others 1
Before Images 2
After Images 5
Average of 9 Transactions
Bytes/Trans ..... 101
Records/Trans ... 1
Files/Trans ..... 1
Partition x00
Total Data Bytes 78
Avg Bytes/Record 26
RestartOK 2
Metadata Records 1
After Images 2
*FileHeader* Partition x00
Total Data Bytes 1388
Avg Bytes/Record 1388
Others 1
LAB_QANFV_ALLQQ.ACTION_TYPES Partition x00
Total Data Bytes 244
Avg Bytes/Record 244
Metadata Records 1
LAB_QANFV_ALLQQ.ACTION_TYPES Partition x0c
Total Data Bytes 156
Avg Bytes/Record 31
Delete 2
Insert 2
Update 1
Before Images 2
After Images 3
Logdump 36 >LOG STOP
Logging stopped
Logdump 37 >EXIT
oracle@qanfv-1-dbs-1b:/software/ogg/191>%
No comments:
Post a Comment