Test: OGG_extarct&reaplict with PK and duplicates

Test: OGG_extarct&reaplict with PK and duplicates

1. Source table without PK and OGG extract set the PK ”PKEY”
2. Target Table has PK “PKEY” and OGG replicat the PK ”PKEY”

–Prepare the testing tables
CREATE TABLE SOURCE.TST_TAB01
(
PKEY NUMBER(19) NOT NULL,
TIME_IN TIMESTAMP(6),
TIME_OUT TIMESTAMP(6),
OGG_DATETIME DATE
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
ROW STORE COMPRESS ADVANCED
NOCACHE
MONITORING;

CREATE TABLE TARGET.TST_TAB02
(
PKEY NUMBER(19) NOT NULL,
TIME_IN TIMESTAMP(6),
TIME_OUT TIMESTAMP(6),
OGG_DATETIME DATE
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
ROW STORE COMPRESS ADVANCED
NOCACHE
MONITORING;

CREATE UNIQUE INDEX TARGET.TST_TAB02_PK ON TARGET.TST_TAB02
(PKEY)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
);

ALTER TABLE TARGET.TST_TAB02 ADD (
CONSTRAINT TST_TAB02_PK
PRIMARY KEY
(PKEY)
USING INDEX TARGET.TST_TAB02_PK
ENABLE VALIDATE);

OGG (https://linuxvm01:18000 LOCAL) 4> view params CSHAE01
extract CSHAE01
useridalias SRCOGGCDB domain SRCOGGCDB
EXTTRAIL /u01/app/oracle/oggma/12.3.0.1.4/DEPLOYMENT_LOCAL/LOCAL/var/lib/data/CMOB/SH
SOURCECATALOG ORCLPDB1
DDL EXCLUDE ALL
LOGALLSUPCOLS
UPDATERECORDFORMAT FULL
TABLE SOURCE.TST_TAB01 KEYCOLS(PKEY);

OGG (https://linuxvm01:18000 LOCAL) 5> view params CSHAR01
replicat CSHAR01
useridalias TRGOGGPDB domain TRGOGGPDB
INCLUDE /u01/app/oracle/oggma/12.3.0.1.4/DEPLOYMENT_LOCAL/LOCAL/etc/conf/ogg/exception_oracle.mac
DBOPTIONS INTEGRATEDPARAMS ( parallelism 2)
DISCARDFILE /u01/app/oracle/oggma/12.3.0.1.4/DEPLOYMENT_LOCAL/LOCAL/var/lib/report/CSHAR01.dsc, APPEND, MEGABYTES 256
DBOPTIONS NOSUPPRESSTRIGGERS
GROUPTRANSOPS 1000
REPERROR (-1, EXCEPTION);
REPERROR (-1403, EXCEPTION);
REPERROR (DEFAULT, EXCEPTION);
REPERROR (DEFAULT2, ABEND);
DDLERROR 904 IGNORE
DDLERROR 942 IGNORE
DDLERROR 955 IGNORE
DDLERROR 959 IGNORE
DDLERROR 1430 IGNORE
DDLERROR 1442 IGNORE
DDLERROR 1917 IGNORE
DDLERROR 2260 IGNORE
DDLERROR 2275 IGNORE
DDLERROR 30567 IGNORE
DDLERROR 32588 IGNORE

MAP ORCLPDB1.SOURCE.TST_TAB01 TARGET TARGET.TST_TAB02 KEYCOLS(PKEY)
COLMAP (USEDEFAULTS, OGG_DATETIME = @DATENOW());
MAP ORCLPDB1.SOURCE.TST_TAB01, #exception_handler_oracle(ogg);

##########################################################
Scenario 1: Insert two duplicates with same PK.
a. Extract capture all two records
b. Replicat apply only one record (first record in trail file)

insert into SOURCE.TST_TAB01(PKEY, TIME_IN, TIME_OUT)
values(225962, to_date(‘1/19/2015 2:20:49.530000’, ‘mm/dd/yyyy HH24:MI:SS.??????’), to_date(‘1/21/2015 11:38:08.093000′,’mm/dd/yyyy HH24:MI:SS.??????’));

insert into SOURCE.TST_TAB01(PKEY, TIME_IN, TIME_OUT)
values(225962, to_date(‘1/19/2016 2:20:49.530000’, ‘mm/dd/yyyy HH24:MI:SS.??????’), to_date(‘1/21/2016 11:38:08.093000′,’mm/dd/yyyy HH24:MI:SS.??????’));

commit;

Logdump 1168 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x00)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 631 (x0277) IO Time : 2019/09/30 10:24:52.112.987
IOType : 170 (xaa) OrigNode : 2 (x02)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
DDR/TDR Idx: (001, 003) AuditPos : 213667856
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 10:24:52.112.987 Metadata Len 631 RBA 14875
Name: ORCLPDB1.SOURCE.TST_TAB01
*
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 ORCLPDB1.SOURCE.TST_TAB01
Record Length: 232
Columns: 7
PKEY 64 20 0 0 0 1 0 20 20 20 0 0 0 0 1 0 1 3 2 -1 0 0 0
TIME_IN 192 29 26 0 0 1 0 29 29 29 0 6 0 0 1 0 0 0 187 -1 0 0 0
TIME_OUT 192 29 58 0 0 1 0 29 29 29 0 6 0 0 1 0 0 0 187 -1 0 0 0
OGG_DATETIME 192 19 90 0 0 1 0 19 19 19 0 5 0 0 1 0 0 0 12 -1 0 0 0
TIME_IN_CHANGED 192 29 112 0 0 1 0 29 29 29 0 6 0 0 1 0 0 0 187 -1 0 0 0
TIME_OUT_CHANGED 192 29 144 0 0 1 0 29 29 29 0 6 0 0 1 0 0 0 187 -1 0 0 0
COL01 64 50 176 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0
End of definition

Logdump 1169 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 187 (x00bb) IO Time : 2019/09/30 10:24:50.000.000
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x00) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 213667856
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 10:24:50.000.000 Delete Len 187 RBA 15579
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
Before Image: Partition 12 G b
0000 0a00 0000 0600 3232 3539 3632 0100 1f00 0000 | ……..225962……
3230 3135 2d30 312d 3139 3a30 323a 3230 3a34 392e | 2015-01-19:02:20:49.
3030 3030 3030 3030 3002 001f 0000 0032 3031 352d | 000000000……2015-
3031 2d32 313a 3131 3a33 383a 3038 2e30 3030 3030 | 01-21:11:38:08.00000
3030 3030 0300 1500 ffff 3139 3030 2d30 312d 3031 | 0000……1900-01-01
3a30 303a 3030 3a30 3004 001f 00ff ff31 3930 302d | :00:00:00……1900-
3031 2d30 313a 3030 3a30 303a 3030 2e30 3030 3030 | 01-01:00:00:00.00000
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3135 2d30 312d 3139 3a30 323a 3230 3a34 | ..2015-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Logdump 1170 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 187 (x00bb) IO Time : 2019/09/30 10:24:50.000.000
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 213668468
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 10:24:50.000.000 Delete Len 187 RBA 15883
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
Before Image: Partition 12 G m
0000 0a00 0000 0600 3232 3539 3632 0100 1f00 0000 | ……..225962……
3230 3136 2d30 312d 3139 3a30 323a 3230 3a34 392e | 2016-01-19:02:20:49.
3030 3030 3030 3030 3002 001f 0000 0032 3031 362d | 000000000……2016-
3031 2d32 313a 3131 3a33 383a 3038 2e30 3030 3030 | 01-21:11:38:08.00000
3030 3030 0300 1500 ffff 3139 3030 2d30 312d 3031 | 0000……1900-01-01
3a30 303a 3030 3a30 3004 001f 00ff ff31 3930 302d | :00:00:00……1900-
3031 2d30 313a 3030 3a30 303a 3030 2e30 3030 3030 | 01-01:00:00:00.00000
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3136 2d30 312d 3139 3a30 323a 3230 3a34 | ..2016-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3136 2d30 312d 3231 3a31 313a 3338 3a30 | ..2016-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Logdump 1171 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 187 (x00bb) IO Time : 2019/09/30 10:24:50.000.000
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 277140496
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 10:24:50.000.000 Insert Len 187 RBA 16150
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
After Image: Partition 12 G m
0000 0a00 0000 0600 3232 3539 3632 0100 1f00 0000 | ……..225962……
3230 3135 2d30 312d 3139 3a30 323a 3230 3a34 392e | 2015-01-19:02:20:49.
3030 3030 3030 3030 3002 001f 0000 0032 3031 352d | 000000000……2015-
3031 2d32 313a 3131 3a33 383a 3038 2e30 3030 3030 | 01-21:11:38:08.00000
3030 3030 0300 1500 ffff 3139 3030 2d30 312d 3031 | 0000……1900-01-01
3a30 303a 3030 3a30 3004 001f 00ff ff31 3930 302d | :00:00:00……1900-
3031 2d30 313a 3030 3a30 303a 3030 2e30 3030 3030 | 01-01:00:00:00.00000
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3135 2d30 312d 3139 3a30 323a 3230 3a34 | ..2015-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Logdump 1172 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 187 (x00bb) IO Time : 2019/09/30 10:24:50.000.000
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x02) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 277140840
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 10:24:50.000.000 Insert Len 187 RBA 16417
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
After Image: Partition 12 G e
0000 0a00 0000 0600 3232 3539 3632 0100 1f00 0000 | ……..225962……
3230 3136 2d30 312d 3139 3a30 323a 3230 3a34 392e | 2016-01-19:02:20:49.
3030 3030 3030 3030 3002 001f 0000 0032 3031 362d | 000000000……2016-
3031 2d32 313a 3131 3a33 383a 3038 2e30 3030 3030 | 01-21:11:38:08.00000
3030 3030 0300 1500 ffff 3139 3030 2d30 312d 3031 | 0000……1900-01-01
3a30 303a 3030 3a30 3004 001f 00ff ff31 3930 302d | :00:00:00……1900-
3031 2d30 313a 3030 3a30 303a 3030 2e30 3030 3030 | 01-01:00:00:00.00000
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3136 2d30 312d 3139 3a30 323a 3230 3a34 | ..2016-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3136 2d30 312d 3231 3a31 313a 3338 3a30 | ..2016-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Replicating from ORCLPDB1.SOURCE.TST_TAB01 to ORCLPDB1.TARGET.TST_TAB02:

*** Total statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 3.00
Total operations 1.00

*** Daily statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 3.00
Total operations 1.00

*** Hourly statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 3.00
Total operations 1.00

*** Latest statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 3.00
Total operations 1.00

Replicating from ORCLPDB1.SOURCE.TST_TAB01 to ORCLPDB1.OGG.EXCEPTIONS:

*** Total statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 2.00
Total discards 0.00
Total operations 3.00

*** Daily statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 2.00
Total discards 0.00
Total operations 3.00

*** Hourly statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 2.00
Total discards 0.00
Total operations 3.00

*** Latest statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 2.00
Total discards 0.00
Total operations 3.00

select * from TARGET.TST_TAB02;
225962 1/19/2015 2:20:49.000000 AM 1/21/2015 11:38:08.000000 AM 9/30/2019 10:38:55 AM

2019-09-30 10:38:43 INFO OGG-06505 MAP resolved (entry ORCLPDB1.SOURCE.TST_TAB01): MAP “ORCLPDB1″.”SOURCE”.”TST_TAB01″ TARGET “ORCLPDB1”.TARGET.TST_TAB02 KEYCOLS(PKEY) COLMAP (USEDEFAULTS, OGG_DATETIME = @DATENOW()).

2019-09-30 10:38:43 INFO OGG-02756 The definition for table ORCLPDB1.SOURCE.TST_TAB01 is obtained from the trail file.
Using the following default columns with matching names:
PKEY=PKEY, TIME_IN=TIME_IN, TIME_OUT=TIME_OUT, TIME_IN_CHANGED=TIME_IN_CHANGED, TIME_OUT_CHANGED=TIME_OUT_CHANGED, COL01=COL01

2019-09-30 10:38:43 INFO OGG-06510 Using the following key columns for target table ORCLPDB1.TARGET.TST_TAB02: PKEY.

2019-09-30 10:38:43 INFO OGG-06505 MAP resolved (entry ORCLPDB1.SOURCE.TST_TAB01): MAP “ORCLPDB1″.”SOURCE”.”TST_TAB01″, TARGET ORCLPDB1.ogg.exceptions , COLMAP ( exception_id = 0 , exception_ts = ” , exception_status = ” , rep_name = @GETENV (‘GGENVIRONMENT’, ‘GROUPNAME’) , table_name = @GETENV (‘GGHEADER’, ‘TABLENAME’) , before_after = @GETENV (‘GGHEADER’, ‘BEFOREAFTERINDICATOR’) , optype = @GETENV (‘LASTERR’, ‘OPTYPE’) , transind = @GETENV ( ‘GGHEADER’, ‘TRANSACTIONINDICATOR’) , logcsn = @GETENV (‘TRANSACTION’, ‘CSN’) , fileseqno = @GETENV (‘RECORD’, ‘FILESEQNO’) , filerba = @GETENV (‘RECORD’, ‘FILERBA’) , logrba = @GETENV (‘GGHEADER’, ‘LOGRBA’) , logposition = @GETENV (‘GGHEADER’, ‘LOGPOSITION’) , committimestamp = @GETENV (‘GGHEADER’, ‘COMMITTIMESTAMP’) , errtype = @GETENV (‘LASTERR’, ‘ERRTYPE’) , errno = @GETENV (‘LASTERR’, ‘DBERRNUM’) , dberrmsg = @GETENV (‘LASTERR’, ‘DBERRMSG’) ) , INSERTALLRECORDS , EXCEPTIONSONLY.

###############################################################3
Scenario 2: Insert one record again with same PK value.
a. Extract capture this record
b. Replicat discards this record.

insert into SOURCE.TST_TAB01(PKEY, TIME_IN, TIME_OUT)
values(225962, to_date(‘1/19/2017 2:20:49.530000’, ‘mm/dd/yyyy HH24:MI:SS.??????’), to_date(‘1/21/2017 11:38:08.093000′,’mm/dd/yyyy HH24:MI:SS.??????’));

commit;

select * from SOURCE.TST_TAB01;
225962 1/19/2015 2:20:49.000000 AM 1/21/2015 11:38:08.000000 AM
225962 1/19/2016 2:20:49.000000 AM 1/21/2016 11:38:08.000000 AM
225962 1/19/2017 2:20:49.000000 AM 1/21/2017 11:38:08.000000 AM

Replicating from ORCLPDB1.SOURCE.TST_TAB01 to ORCLPDB1.TARGET.TST_TAB02:

*** Total statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 4.00
Total operations 1.00

*** Daily statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 4.00
Total operations 1.00

*** Hourly statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 4.00
Total operations 1.00

*** Latest statistics since 2019-09-30 10:38:43 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 4.00
Total operations 1.00

Replicating from ORCLPDB1.SOURCE.TST_TAB01 to ORCLPDB1.OGG.EXCEPTIONS:

*** Total statistics since 2019-09-30 10:38:43 ***
Total inserts 2.00
Total updates 0.00
Total deletes 2.00
Total discards 0.00
Total operations 4.00

*** Daily statistics since 2019-09-30 10:38:43 ***
Total inserts 2.00
Total updates 0.00
Total deletes 2.00
Total discards 0.00
Total operations 4.00

*** Hourly statistics since 2019-09-30 10:38:43 ***
Total inserts 2.00
Total updates 0.00
Total deletes 2.00
Total discards 0.00
Total operations 4.00

*** Latest statistics since 2019-09-30 10:38:43 ***
Total inserts 2.00
Total updates 0.00
Total deletes 2.00
Total discards 0.00
Total operations 4.00

col ERRNO format a10
select trunc(exception_ts,’HH24′ ),sum(1),errno
from ogg.EXCEPTIONS where committimestamp >= sysdate -90
and REP_NAME=’CSHAR01′ group by trunc(exception_ts,’HH24′ ) , errno order by 1 desc ;

OCI Error ORA-00001: unique constraint (TARGET.TST_TAB02_PK) violated (status = 1), SQL <INSERT INTO “SOURCE”.”TST_TAB02″ (“PKEY”,”TIME_IN”,”TIME_OUT”,”OGG_DATETIME”,”TIME_IN_CHANGED”,”TIME_OUT_CHANGED”,”COL01″) VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6)>

9/30/2019 10:55:26.294424 AM CSHAR01 ORCLPDB1.SOURCE.TST_TAB01 AFTER INSERT WHOLE 846096558 0 105912 4545 589550096 9/30/2019 10:55:19.000000 AM DB 1 OCI Error ORA-00001: unique constraint (TARGET.TST_TAB02_PK) violated (status = 1), SQL <INSERT INTO “SOURCE”.”TST_TAB02″ (“PKEY”,”TIME_IN”,”TIME_OUT”,”OGG_DATETIME”,”TIME_IN_CHANGED”,”TIME_OUT_CHANGED”,”COL01″) VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6)>
9/30/2019 10:38:55.343628 AM CSHAR01 ORCLPDB1.SOURCE.TST_TAB01 AFTER INSERT END 846024474 0 16417 4545 277140840 9/30/2019 10:24:50.000000 AM DB 1 OCI Error ORA-00001: unique constraint (TARGET.TST_TAB02_PK) violated (status = 1), SQL <INSERT INTO “SOURCE”.”TST_TAB02″ (“PKEY”,”TIME_IN”,”TIME_OUT”,”OGG_DATETIME”,”TIME_IN_CHANGED”,”TIME_OUT_CHANGED”,”COL01″) VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6)>

##############################################
Scenario 3: update records with PK.
a. All three records updated.
b. Extract capture all three update transactions in trail as the physical order.
c. Replicat apply only update transaction to target table (first record in trail file)

update SOURCE.TST_TAB01 set TIME_IN=to_date(‘9/19/2018 3:20:49.530000’, ‘mm/dd/yyyy HH24:MI:SS.??????’) where gkey=225962;
commit;
3 rows updated.
Commit complete.

225962 9/19/2018 3:20:49.000000 AM 1/21/2015 11:38:08.000000 AM
225962 9/19/2018 3:20:49.000000 AM 1/21/2016 11:38:08.000000 AM
225962 9/19/2018 3:20:49.000000 AM 1/21/2017 11:38:08.000000 AM

Extracting from ORCLPDB1.SOURCE.TST_TAB01 to ORCLPDB1.SOURCE.TST_TAB01:

*** Total statistics since 2019-09-30 10:22:26 ***
Total inserts 3.00
Total updates 3.00
Total deletes 2.00
Total discards 0.00
Total operations 8.00

*** Daily statistics since 2019-09-30 10:22:26 ***
Total inserts 3.00
Total updates 3.00
Total deletes 2.00
Total discards 0.00
Total operations 8.00

*** Hourly statistics since 2019-09-30 11:00:00 ***
Total inserts 0.00
Total updates 3.00
Total deletes 0.00
Total discards 0.00
Total operations 3.00

*** Latest statistics since 2019-09-30 10:22:26 ***
Total inserts 3.00
Total updates 3.00
Total deletes 2.00
Total discards 0.00
Total operations 8.00

Logdump 1260 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 378 (x017a) IO Time : 2019/09/30 11:02:15.000.000
IOType : 134 (x86) OrigNode : 255 (xff)
TransInd : . (x00) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 655260072
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:02:15.000.000 GGSUnifiedUpdate Len 378 RBA 126365
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
After Image: Partition 12 G b
bb00 0000 0000 0a00 0000 0600 3232 3539 3632 0100 | …………225962..
1f00 0000 3230 3135 2d30 312d 3139 3a30 323a 3230 | ….2015-01-19:02:20
3a34 392e 3030 3030 3030 3030 3002 001f 0000 0032 | :49.000000000……2
3031 352d 3031 2d32 313a 3131 3a33 383a 3038 2e30 | 015-01-21:11:38:08.0
3030 3030 3030 3030 0300 1500 ffff 3139 3030 2d30 | 00000000……1900-0
312d 3031 3a30 303a 3030 3a30 3004 001f 00ff ff31 | 1-01:00:00:00……1
3930 302d 3031 2d30 313a 3030 3a30 303a 3030 2e30 | 900-01-01:00:00:00.0
Before Image Len 191 (x000000bf)
BeforeColumnLen 187 (x000000bb)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3135 2d30 312d 3139 3a30 323a 3230 3a34 | ..2015-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

After Image Len 187 (x000000bb)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3138 2d30 392d 3139 3a30 333a 3230 3a34 | ..2018-09-19:03:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Logdump 1259 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 378 (x017a) IO Time : 2019/09/30 11:02:15.000.000
IOType : 134 (x86) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 655260724
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:02:15.000.000 GGSUnifiedUpdate Len 378 RBA 126859
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
After Image: Partition 12 G m
bb00 0000 0000 0a00 0000 0600 3232 3539 3632 0100 | …………225962..
1f00 0000 3230 3136 2d30 312d 3139 3a30 323a 3230 | ….2016-01-19:02:20
3a34 392e 3030 3030 3030 3030 3002 001f 0000 0032 | :49.000000000……2
3031 362d 3031 2d32 313a 3131 3a33 383a 3038 2e30 | 016-01-21:11:38:08.0
3030 3030 3030 3030 0300 1500 ffff 3139 3030 2d30 | 00000000……1900-0
312d 3031 3a30 303a 3030 3a30 3004 001f 00ff ff31 | 1-01:00:00:00……1
3930 302d 3031 2d30 313a 3030 3a30 303a 3030 2e30 | 900-01-01:00:00:00.0
Before Image Len 191 (x000000bf)
BeforeColumnLen 187 (x000000bb)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3136 2d30 312d 3139 3a30 323a 3230 3a34 | ..2016-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3136 2d30 312d 3231 3a31 313a 3338 3a30 | ..2016-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

After Image Len 187 (x000000bb)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3138 2d30 392d 3139 3a30 333a 3230 3a34 | ..2018-09-19:03:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3136 2d30 312d 3231 3a31 313a 3338 3a30 | ..2016-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Logdump 1258 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 378 (x017a) IO Time : 2019/09/30 11:02:15.000.000
IOType : 134 (x86) OrigNode : 255 (xff)
TransInd : . (x02) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 655261064
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:02:15.000.000 GGSUnifiedUpdate Len 378 RBA 127317
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
After Image: Partition 12 G e
bb00 0000 0000 0a00 0000 0600 3232 3539 3632 0100 | …………225962..
1f00 0000 3230 3137 2d30 312d 3139 3a30 323a 3230 | ….2017-01-19:02:20
3a34 392e 3030 3030 3030 3030 3002 001f 0000 0032 | :49.000000000……2
3031 372d 3031 2d32 313a 3131 3a33 383a 3038 2e30 | 017-01-21:11:38:08.0
3030 3030 3030 3030 0300 1500 ffff 3139 3030 2d30 | 00000000……1900-0
312d 3031 3a30 303a 3030 3a30 3004 001f 00ff ff31 | 1-01:00:00:00……1
3930 302d 3031 2d30 313a 3030 3a30 303a 3030 2e30 | 900-01-01:00:00:00.0
Before Image Len 191 (x000000bf)
BeforeColumnLen 187 (x000000bb)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3137 2d30 312d 3139 3a30 323a 3230 3a34 | ..2017-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3137 2d30 312d 3231 3a31 313a 3338 3a30 | ..2017-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

After Image Len 187 (x000000bb)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3138 2d30 392d 3139 3a30 333a 3230 3a34 | ..2018-09-19:03:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3137 2d30 312d 3231 3a31 313a 3338 3a30 | ..2017-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

2019-09-30 10:55:26 WARNING OGG-02544 Unhandled error (ORA-26799: unique constraint TARGET.TST_TAB02_PK violated for table TARGET.TST_TAB02 with column values (“PKEY”) = (225962)
ORA-00001: unique constraint (TARGET.TST_TAB02_PK) violated
ORA-00001: unique constraint (TARGET.TST_TAB02_PK) violated) while processing the record at SEQNO 0, RBA 105912 in Integrated mode. REPLICAT will retry in Direct mode.

select * from TARGET.TST_TAB02;
225962 9/19/2018 3:20:49.000000 AM 1/21/2017 11:38:08.000000 AM 9/30/2019 11:02:18 AM

select *
from ogg.EXCEPTIONS where committimestamp >= sysdate -90
and REP_NAME=’CSHAR01′ order by EXCEPTION_TS desc ;

################################################
Scenario 4: delete records with PK,
a. All records deleted
b. Extract capture all delete transactions in trail file.
c. Replicat delete all data.
delete from SOURCE.TST_TAB01;
commit;

Logdump 1308 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 187 (x00bb) IO Time : 2019/09/30 11:25:42.000.000
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x00) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 853719300
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:25:42.000.000 Delete Len 187 RBA 195502
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
Before Image: Partition 12 G b
0000 0a00 0000 0600 3232 3539 3633 0100 1f00 0000 | ……..225963……
3230 3230 2d30 392d 3139 3a30 333a 3230 3a34 392e | 2020-09-19:03:20:49.
3030 3030 3030 3030 3002 001f 0000 0032 3031 352d | 000000000……2015-
3031 2d32 313a 3131 3a33 383a 3038 2e30 3030 3030 | 01-21:11:38:08.00000
3030 3030 0300 1500 ffff 3139 3030 2d30 312d 3031 | 0000……1900-01-01
3a30 303a 3030 3a30 3004 001f 00ff ff31 3930 302d | :00:00:00……1900-
3031 2d30 313a 3030 3a30 303a 3030 2e30 3030 3030 | 01-01:00:00:00.00000
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3633 | ….225963
Column 1 (x0001), Len 31 (x001f)
0000 3230 3230 2d30 392d 3139 3a30 333a 3230 3a34 | ..2020-09-19:03:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Logdump 1309 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 187 (x00bb) IO Time : 2019/09/30 11:25:42.000.000
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 853719892
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:25:42.000.000 Delete Len 187 RBA 195805
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
Before Image: Partition 12 G m
0000 0a00 0000 0600 3232 3539 3633 0100 1f00 0000 | ……..225963……
3230 3230 2d30 392d 3139 3a30 333a 3230 3a34 392e | 2020-09-19:03:20:49.
3030 3030 3030 3030 3002 001f 0000 0032 3031 352d | 000000000……2015-
3031 2d32 313a 3131 3a33 383a 3038 2e30 3030 3030 | 01-21:11:38:08.00000
3030 3030 0300 1500 ffff 3139 3030 2d30 312d 3031 | 0000……1900-01-01
3a30 303a 3030 3a30 3004 001f 00ff ff31 3930 302d | :00:00:00……1900-
3031 2d30 313a 3030 3a30 303a 3030 2e30 3030 3030 | 01-01:00:00:00.00000
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3633 | ….225963
Column 1 (x0001), Len 31 (x001f)
0000 3230 3230 2d30 392d 3139 3a30 333a 3230 3a34 | ..2020-09-19:03:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Logdump 1310 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 187 (x00bb) IO Time : 2019/09/30 11:25:42.000.000
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 853720212
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:25:42.000.000 Delete Len 187 RBA 196072
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
Before Image: Partition 12 G m
0000 0a00 0000 0600 3232 3539 3632 0100 1f00 0000 | ……..225962……
3230 3138 2d30 392d 3139 3a30 333a 3230 3a34 392e | 2018-09-19:03:20:49.
3030 3030 3030 3030 3002 001f 0000 0032 3031 352d | 000000000……2015-
3031 2d32 313a 3131 3a33 383a 3038 2e30 3030 3030 | 01-21:11:38:08.00000
3030 3030 0300 1500 ffff 3139 3030 2d30 312d 3031 | 0000……1900-01-01
3a30 303a 3030 3a30 3004 001f 00ff ff31 3930 302d | :00:00:00……1900-
3031 2d30 313a 3030 3a30 303a 3030 2e30 3030 3030 | 01-01:00:00:00.00000
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3138 2d30 392d 3139 3a30 333a 3230 3a34 | ..2018-09-19:03:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Logdump 1311 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 187 (x00bb) IO Time : 2019/09/30 11:25:42.000.000
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 853720516
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:25:42.000.000 Delete Len 187 RBA 196339
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
Before Image: Partition 12 G m
0000 0a00 0000 0600 3232 3539 3632 0100 1f00 0000 | ……..225962……
3230 3138 2d30 392d 3139 3a30 333a 3230 3a34 392e | 2018-09-19:03:20:49.
3030 3030 3030 3030 3002 001f 0000 0032 3031 362d | 000000000……2016-
3031 2d32 313a 3131 3a33 383a 3038 2e30 3030 3030 | 01-21:11:38:08.00000
3030 3030 0300 1500 ffff 3139 3030 2d30 312d 3031 | 0000……1900-01-01
3a30 303a 3030 3a30 3004 001f 00ff ff31 3930 302d | :00:00:00……1900-
3031 2d30 313a 3030 3a30 303a 3030 2e30 3030 3030 | 01-01:00:00:00.00000
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3138 2d30 392d 3139 3a30 333a 3230 3a34 | ..2018-09-19:03:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3136 2d30 312d 3231 3a31 313a 3338 3a30 | ..2016-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Logdump 1312 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 187 (x00bb) IO Time : 2019/09/30 11:25:42.000.000
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x02) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 853720836
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:25:42.000.000 Delete Len 187 RBA 196606
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
Before Image: Partition 12 G e
0000 0a00 0000 0600 3232 3539 3632 0100 1f00 0000 | ……..225962……
3230 3138 2d30 392d 3139 3a30 333a 3230 3a34 392e | 2018-09-19:03:20:49.
3030 3030 3030 3030 3002 001f 0000 0032 3031 372d | 000000000……2017-
3031 2d32 313a 3131 3a33 383a 3038 2e30 3030 3030 | 01-21:11:38:08.00000
3030 3030 0300 1500 ffff 3139 3030 2d30 312d 3031 | 0000……1900-01-01
3a30 303a 3030 3a30 3004 001f 00ff ff31 3930 302d | :00:00:00……1900-
3031 2d30 313a 3030 3a30 303a 3030 2e30 3030 3030 | 01-01:00:00:00.00000
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3138 2d30 392d 3139 3a30 333a 3230 3a34 | ..2018-09-19:03:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3137 2d30 312d 3231 3a31 313a 3338 3a30 | ..2017-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

################################################
Scenario 5: Update record with normal Column not PK column,
a. Only 1 record updated with right condition.
b. Extract capture this transaction in trail file.
c. Replicat update the record with PK (if both before and after image existing in trail file, the other normal column will also be updated with the latest value)

update SOURCE.TST_TAB01 set TIME_IN=to_date(‘1/1/2021 3:20:49.530000’, ‘mm/dd/yyyy HH24:MI:SS.??????’) where COL01=2;
commit;

select * from SOURCE.TST_TAB01;
225962 1/19/2015 2:20:49.000000 AM 1/21/2015 11:38:08.000000 AM 1
225962 1/1/2021 3:20:49.000000 AM 1/21/2016 11:38:08.000000 AM 2

select * from TARGET.TST_TAB02;
225962 1/1/2021 3:20:49.000000 AM 1/21/2016 11:38:08.000000 AM 9/30/2019 11:33:45 AM 2

Logdump 1341 >N
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 380 (x017c) IO Time : 2019/09/30 11:33:41.000.000
IOType : 134 (x86) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4546 AuditPos : 8792592
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:33:41.000.000 GGSUnifiedUpdate Len 380 RBA 220474
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
After Image: Partition 12 G s
bc00 0000 0000 0a00 0000 0600 3232 3539 3632 0100 | …………225962..
1f00 0000 3230 3136 2d30 312d 3139 3a30 323a 3230 | ….2016-01-19:02:20
3a34 392e 3030 3030 3030 3030 3002 001f 0000 0032 | :49.000000000……2
3031 362d 3031 2d32 313a 3131 3a33 383a 3038 2e30 | 016-01-21:11:38:08.0
3030 3030 3030 3030 0300 1500 ffff 3139 3030 2d30 | 00000000……1900-0
312d 3031 3a30 303a 3030 3a30 3004 001f 00ff ff31 | 1-01:00:00:00……1
3930 302d 3031 2d30 313a 3030 3a30 303a 3030 2e30 | 900-01-01:00:00:00.0
Before Image Len 192 (x000000c0)
BeforeColumnLen 188 (x000000bc)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3136 2d30 312d 3139 3a30 323a 3230 3a34 | ..2016-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3136 2d30 312d 3231 3a31 313a 3338 3a30 | ..2016-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 5 (x0005)
0000 0100 32 | ….2

After Image Len 188 (x000000bc)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3632 | ….225962
Column 1 (x0001), Len 31 (x001f)
0000 3230 3231 2d30 312d 3031 3a30 333a 3230 3a34 | ..2021-01-01:03:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3136 2d30 312d 3231 3a31 313a 3338 3a30 | ..2016-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 5 (x0005)
0000 0100 32 | ….2

################################################
Scenario 6: Insert new two duplicates with new PK.
a. Extract capture all two records
b. Replicat apply only new additional one record (first record in trail file)

insert into SOURCE.TST_TAB01(PKEY, TIME_IN, TIME_OUT)
values(225963, to_date(‘1/19/2015 2:20:49.530000’, ‘mm/dd/yyyy HH24:MI:SS.??????’), to_date(‘1/21/2015 11:38:08.093000′,’mm/dd/yyyy HH24:MI:SS.??????’));
insert into SOURCE.TST_TAB01(PKEY, TIME_IN, TIME_OUT)
values(225963, to_date(‘1/19/2015 2:20:49.530000’, ‘mm/dd/yyyy HH24:MI:SS.??????’), to_date(‘1/21/2015 11:38:08.093000′,’mm/dd/yyyy HH24:MI:SS.??????’));
commit;

select * from SOURCE.TST_TAB01;
225963 1/19/2015 2:20:49.000000 AM 1/21/2015 11:38:08.000000 AM
225963 1/19/2015 2:20:49.000000 AM 1/21/2015 11:38:08.000000 AM
225962 9/19/2018 3:20:49.000000 AM 1/21/2015 11:38:08.000000 AM
225962 9/19/2018 3:20:49.000000 AM 1/21/2016 11:38:08.000000 AM
225962 9/19/2018 3:20:49.000000 AM 1/21/2017 11:38:08.000000 AM

select * from TARGET.TST_TAB02;
225962 9/19/2018 3:20:49.000000 AM 1/21/2017 11:38:08.000000 AM 9/30/2019 11:02:18 AM
225963 1/19/2015 2:20:49.000000 AM 1/21/2015 11:38:08.000000 AM 9/30/2019 11:18:31 AM

Logdump 1280 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 187 (x00bb) IO Time : 2019/09/30 11:18:25.000.000
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x00) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 794440720
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:18:25.000.000 Insert Len 187 RBA 173828
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
After Image: Partition 12 G b
0000 0a00 0000 0600 3232 3539 3633 0100 1f00 0000 | ……..225963……
3230 3135 2d30 312d 3139 3a30 323a 3230 3a34 392e | 2015-01-19:02:20:49.
3030 3030 3030 3030 3002 001f 0000 0032 3031 352d | 000000000……2015-
3031 2d32 313a 3131 3a33 383a 3038 2e30 3030 3030 | 01-21:11:38:08.00000
3030 3030 0300 1500 ffff 3139 3030 2d30 312d 3031 | 0000……1900-01-01
3a30 303a 3030 3a30 3004 001f 00ff ff31 3930 302d | :00:00:00……1900-
3031 2d30 313a 3030 3a30 303a 3030 2e30 3030 3030 | 01-01:00:00:00.00000
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3633 | ….225963
Column 1 (x0001), Len 31 (x001f)
0000 3230 3135 2d30 312d 3139 3a30 323a 3230 3a34 | ..2015-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Logdump 1281 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 187 (x00bb) IO Time : 2019/09/30 11:18:25.000.000
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x02) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 794441312
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:18:25.000.000 Insert Len 187 RBA 174131
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
After Image: Partition 12 G e
0000 0a00 0000 0600 3232 3539 3633 0100 1f00 0000 | ……..225963……
3230 3135 2d30 312d 3139 3a30 323a 3230 3a34 392e | 2015-01-19:02:20:49.
3030 3030 3030 3030 3002 001f 0000 0032 3031 352d | 000000000……2015-
3031 2d32 313a 3131 3a33 383a 3038 2e30 3030 3030 | 01-21:11:38:08.00000
3030 3030 0300 1500 ffff 3139 3030 2d30 312d 3031 | 0000……1900-01-01
3a30 303a 3030 3a30 3004 001f 00ff ff31 3930 302d | :00:00:00……1900-
3031 2d30 313a 3030 3a30 303a 3030 2e30 3030 3030 | 01-01:00:00:00.00000
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3633 | ….225963
Column 1 (x0001), Len 31 (x001f)
0000 3230 3135 2d30 312d 3139 3a30 323a 3230 3a34 | ..2015-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

–update new record with PK.
update SOURCE.TST_TAB01 set TIME_IN=to_date(‘9/19/2020 3:20:49.530000’, ‘mm/dd/yyyy HH24:MI:SS.??????’) where gkey=225963;
commit;
2 rows updated.
Commit complete.

Logdump 1294 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 378 (x017a) IO Time : 2019/09/30 11:22:31.000.000
IOType : 134 (x86) OrigNode : 255 (xff)
TransInd : . (x00) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 829446672
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:22:31.000.000 GGSUnifiedUpdate Len 378 RBA 185912
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
After Image: Partition 12 G b
bb00 0000 0000 0a00 0000 0600 3232 3539 3633 0100 | …………225963..
1f00 0000 3230 3135 2d30 312d 3139 3a30 323a 3230 | ….2015-01-19:02:20
3a34 392e 3030 3030 3030 3030 3002 001f 0000 0032 | :49.000000000……2
3031 352d 3031 2d32 313a 3131 3a33 383a 3038 2e30 | 015-01-21:11:38:08.0
3030 3030 3030 3030 0300 1500 ffff 3139 3030 2d30 | 00000000……1900-0
312d 3031 3a30 303a 3030 3a30 3004 001f 00ff ff31 | 1-01:00:00:00……1
3930 302d 3031 2d30 313a 3030 3a30 303a 3030 2e30 | 900-01-01:00:00:00.0
Before Image Len 191 (x000000bf)
BeforeColumnLen 187 (x000000bb)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3633 | ….225963
Column 1 (x0001), Len 31 (x001f)
0000 3230 3135 2d30 312d 3139 3a30 323a 3230 3a34 | ..2015-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

After Image Len 187 (x000000bb)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3633 | ….225963
Column 1 (x0001), Len 31 (x001f)
0000 3230 3230 2d30 392d 3139 3a30 333a 3230 3a34 | ..2020-09-19:03:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

Logdump 1295 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 378 (x017a) IO Time : 2019/09/30 11:22:31.000.000
IOType : 134 (x86) OrigNode : 255 (xff)
TransInd : . (x02) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 4545 AuditPos : 829447352
Continued : N (x00) RecCount : 1 (x01)

2019/09/30 11:22:31.000.000 GGSUnifiedUpdate Len 378 RBA 186408
Name: ORCLPDB1.SOURCE.TST_TAB01 (TDR Index: 3)
After Image: Partition 12 G e
bb00 0000 0000 0a00 0000 0600 3232 3539 3633 0100 | …………225963..
1f00 0000 3230 3135 2d30 312d 3139 3a30 323a 3230 | ….2015-01-19:02:20
3a34 392e 3030 3030 3030 3030 3002 001f 0000 0032 | :49.000000000……2
3031 352d 3031 2d32 313a 3131 3a33 383a 3038 2e30 | 015-01-21:11:38:08.0
3030 3030 3030 3030 0300 1500 ffff 3139 3030 2d30 | 00000000……1900-0
312d 3031 3a30 303a 3030 3a30 3004 001f 00ff ff31 | 1-01:00:00:00……1
3930 302d 3031 2d30 313a 3030 3a30 303a 3030 2e30 | 900-01-01:00:00:00.0
Before Image Len 191 (x000000bf)
BeforeColumnLen 187 (x000000bb)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3633 | ….225963
Column 1 (x0001), Len 31 (x001f)
0000 3230 3135 2d30 312d 3139 3a30 323a 3230 3a34 | ..2015-01-19:02:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

After Image Len 187 (x000000bb)
Column 0 (x0000), Len 10 (x000a)
0000 0600 3232 3539 3633 | ….225963
Column 1 (x0001), Len 31 (x001f)
0000 3230 3230 2d30 392d 3139 3a30 333a 3230 3a34 | ..2020-09-19:03:20:4
392e 3030 3030 3030 3030 30 | 9.000000000
Column 2 (x0002), Len 31 (x001f)
0000 3230 3135 2d30 312d 3231 3a31 313a 3338 3a30 | ..2015-01-21:11:38:0
382e 3030 3030 3030 3030 30 | 8.000000000
Column 3 (x0003), Len 21 (x0015)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
30 | 0
Column 4 (x0004), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 5 (x0005), Len 31 (x001f)
ffff 3139 3030 2d30 312d 3031 3a30 303a 3030 3a30 | ..1900-01-01:00:00:0
302e 3030 3030 3030 3030 30 | 0.000000000
Column 6 (x0006), Len 4 (x0004)
ffff 0000 | ….

select * from TARGET.TST_TAB02;
225962 9/19/2018 3:20:49.000000 AM 1/21/2017 11:38:08.000000 AM 9/30/2019 11:02:18 AM
225963 9/19/2020 3:20:49.000000 AM 1/21/2015 11:38:08.000000 AM 9/30/2019 11:22:34 AM

Reference:
http://www.ateam-oracle.com/oracle-goldengate-tables-without-keys

Leave a Reply

Your email address will not be published. Required fields are marked *