源端操作:insert into lz.zm values(5);--commit
目标端没有数据更新。
源端ogg ggserr.log日志
2019-08-18T21:20:18.086+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2019-08-18T21:20:18.537+0800 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, eora4.prm: Setting session time zone to source database time zone 'GMT'.
2019-08-18T21:20:27.293+0800 INFO OGG-02255 Oracle GoldenGate Capture for Oracle, eora4.prm: The MININGDBLOGIN is connected to the source database ORCL.
2019-08-18T21:20:27.441+0800 INFO OGG-06604 Oracle GoldenGate Capture for Oracle, eora4.prm: Database ORCL CPU info: CPU Count 1, CPU Core Count 0, CPU Socket Count 0.
2019-08-18T21:20:34.633+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2019-08-18T21:20:36.306+0800 WARNING OGG-02045 Oracle GoldenGate Capture for Oracle, eora4.prm: Database does not have streams_pool_size initialization parameter configured.
2019-08-18T21:20:39.589+0800 INFO OGG-02248 Oracle GoldenGate Capture for Oracle, eora4.prm: Logmining server DDL filtering enabled.
2019-08-18T21:20:42.939+0800 INFO OGG-02068 Oracle GoldenGate Capture for Oracle, eora4.prm: Integrated capture successfully attached to logmining server OGG$CAP_EORA4 using OGGCapture API.
2019-08-18T21:20:42.941+0800 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, eora4.prm: Source redo compatibility version is: 12.2.0.
2019-08-18T21:20:42.951+0800 INFO OGG-02086 Oracle GoldenGate Capture for Oracle, eora4.prm: Integrated Dictionary will be used.
2019-08-18T21:20:45.108+0800 WARNING OGG-02905 Oracle GoldenGate Capture for Oracle, eora4.prm: Replication of OID column in object tables may diverge.
2019-08-18T21:20:45.188+0800 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, eora4.prm: EXTRACT EORA4 started.
2019-08-18T21:20:45.396+0800 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, eora4.prm: No recovery is required for target file ./dirdat/eo000000000, at RBA 0 (file not opened).
2019-08-18T21:20:45.396+0800 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, eora4.prm: Output file ./dirdat/eo is using format RELEASE 12.3.
2019-08-18T21:20:46.362+0800 INFO OGG-02243 Oracle GoldenGate Capture for Oracle, pump4.prm: Opened trail file /home/oracle/ogg/dirdat/eo000000000 at 2019-08-18 21:20:46.362485.
2019-08-18T21:20:46.362+0800 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, pump4.prm: Output file ./dirdat/pu is using format RELEASE 12.3.
2019-08-18T21:20:49.842+0800 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, eora4.prm: Setting session time zone to source database time zone 'GMT'.
2019-08-18T21:22:16.171+0800 INFO OGG-06507 Oracle GoldenGate Capture for Oracle, eora4.prm: MAP (TABLE) resolved (entry PDB1.lz.zm): TABLE "PDB1"."LZ"."ZM".
2019-08-18T21:22:24.344+0800 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, eora4.prm: Using the following key columns for source table PDB1.LZ.ZM: ID.
2019-08-18T21:22:24.409+0800 INFO OGG-06507 Oracle GoldenGate Capture for Oracle, eora4.prm: MAP (TABLE) resolved (entry PDB1.lz.zm): TABLE "PDB1"."LZ"."ZM".
2019-08-18T21:22:24.462+0800 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, eora4.prm: Using the following key columns for source table PDB1.LZ.ZM: ID.
2019-08-18T21:22:25.840+0800 INFO OGG-02263 Oracle GoldenGate Capture for Oracle, pump4.prm: Passthru MAP (TABLE) resolved (entry PDB1.lz.zm): TABLE "PDB1"."LZ"."ZM".
目标端 ogg ggserr.log
2019-08-14T00:26:42.980+0800 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repl4.prm: REPLICAT REPL4 started.
2019-08-14T00:26:42.980+0800 INFO OGG-02243 Oracle GoldenGate Delivery for Oracle, repl4.prm: Opened trail file /home/oracle/ogg1/dirdat/pu000000000 at 2019-08-14 00:26:42.980666.
2019-08-14T00:26:43.869+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2019-08-14T00:30:49.319+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2019-08-14T00:31:49.794+0800 INFO OGG-03522 Oracle GoldenGate Delivery for Oracle, repl4.prm: Setting session time zone to source database time zone 'GMT'.
2019-08-14T00:31:49.921+0800 WARNING OGG-02760 Oracle GoldenGate Delivery for Oracle, repl4.prm: ASSUMETARGETDEFS is ignored because trail file /home/oracle/ogg1/dirdat/pu000000000 contains table definitions.
2019-08-14T00:31:52.175+0800 INFO OGG-03506 Oracle GoldenGate Delivery for Oracle, repl4.prm: The source database character set, as determined from the trail file, is UTF-8.
2019-08-14T00:31:52.342+0800 INFO OGG-06505 Oracle GoldenGate Delivery for Oracle, repl4.prm: MAP resolved (entry PDB1.LZ.ZM): MAP "PDB1"."LZ"."ZM",TARGET nzw.nz.
2019-08-14T00:31:56.776+0800 INFO OGG-02756 Oracle GoldenGate Delivery for Oracle, repl4.prm: The definition for table PDB1.LZ.ZM is obtained from the trail file.
2019-08-14T00:31:56.823+0800 INFO OGG-06511 Oracle GoldenGate Delivery for Oracle, repl4.prm: Using following columns in default map by name: ID.
2019-08-14T00:31:56.823+0800 INFO OGG-06510 Oracle GoldenGate Delivery for Oracle, repl4.prm: Using the following key columns for target table NZW.NZ: ID.