Supplemental logging not working correctly after add schematrandata.
(Doc ID 3077768.1)
Last updated on MARCH 19, 2025
Applies to:
Oracle GoldenGate - Version 19.22.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 19.22.0.0 version
Supplemental logging not working correctly after add schematrandata.
The table had no PK, UI, etc. and logging was turned on for all columns.
1. LOGMNR$ALWAYS_SUPLOG_COLUMNS
SQL> SELECT column_name FROM table(LOGMNR$ALWAYS_SUPLOG_COLUMNS('OGG','TABLE'));
COL1
COL2
COL3
COL4
COL5
2. info schematrandata
GGSCI> info schematrandata ogg
2025-03-17 05:47:59 INFO OGG-06480 Schema level supplemental logging, excluding non-validated keys, is enabled on schema "OGG".
2025-03-17 05:47:59 INFO OGG-01980 Schema level supplemental logging is enabled on schema "OGG" for all scheduling columns.
2025-03-17 05:47:59 INFO OGG-10462 Schema "OGG" have 29 prepared tables for instantiation.
3. info trandata
GGSCI> info trandata ogg.table
2025-03-17 05:48:19 INFO OGG-06480 Schema level supplemental logging, excluding non-validated keys, is enabled on schema "OGG".
2025-03-17 05:48:19 INFO OGG-01980 Schema level supplemental logging is enabled on schema "OGG" for all scheduling columns.
2025-03-17 05:48:19 INFO OGG-10471 ***** Oracle Goldengate support information on table OGG.TABLE *****
Oracle Goldengate support native capture on table OGG.TABLE.
Oracle Goldengate marked following column as key columns on table OGG.TABLE: ID, COL1, COL2, COL3, COL4, COL5L
No unique key is defined for table OGG.TABLE.
Logging of supplemental redo log data is enabled for table OGG.TABLE.
Columns supplementally logged for table OGG.TABLE: "COL1", "COL2", "COL3", "COL4", "COL5".
Prepared CSN for table OGG.TABLE: 684773612
4. Before / After Image
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 27 (x001b) IO Time : 2025/03/18 02:09:15.000.000
IOType : 135 (x87) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 88659 AuditPos : 4679696
Continued : N (x00) RecCount : 1 (x01)
2025/03/18 02:09:15.000.000 GGSUnifiedPKUpdate Len 27 RBA 207508686
Name: OGG.TABLE (TDR Index: 3)
After Image: Partition x0c G s
0c00 0000 0100 0800 0000 0400 7465 7374 0100 0700 | ............test....
0000 0300 7361 6d | ....sam
Before Image Len 16 (x00000010)
BeforeColumnLen 12 (x0000000c)
Column 1 (x0001), Len 8 (x0008)
0000 0400 7465 7374 | ....test
After Image Len 11 (x0000000b)
Column 1 (x0001), Len 7 (x0007)
0000 0300 7361 6d | ....sam
Changes
Customer has executed "DELETE TRANDATA".
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |