We have 12.2 GG with 11g RDBMS. We have two extra columns on target, which we are populating with inserts and updates on source tables. Our GG replicate is failing with below errors. Replicate is looking for old trail file which was purged by GG itself. Please find the attached log files for more details.
2017-01-10 10:33:57 INFO OGG-06451 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Triggers will be suppressed by default.
2017-01-10 10:33:57 INFO OGG-01971 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: The previous message, 'INFO OGG-06451', repeated 1 times.
2017-01-10 10:33:57 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/opt/gg/bin/12.2.1/dirtmp.
2017-01-10 10:33:57 WARNING OGG-05673 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: CSN-based duplicate suppression is disabled because there is no checkpoint table for this Replicat.
2017-01-10 10:33:57 INFO OGG-02545 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Parameter GROUPTRANSOPS is ignored by Integrated Replicat when parallelism is greater than 1.
2017-01-10 10:33:57 INFO OGG-02527 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Integrated Replicat does not populate a trace table.
2017-01-10 10:33:58 INFO OGG-02530 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Integrated replicat successfully attached to inbound server OGG$RFCRS01A.
2017-01-10 10:33:58 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: REPLICAT RFCRS01A started.
2017-01-10 10:33:58 ERROR OGG-02171 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Error reading LCR from data source. Status 500, data source type 0.
2017-01-10 10:33:58 ERROR OGG-01091 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Unable to open file "/opt/gg/dirdat/FACS02A/pn000000001" (error 2, No such file or directory).
2017-01-10 10:33:59 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (ggadmin): info all.
2017-01-10 10:34:04 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: PROCESS ABENDING.
Replicat mapping:
Replicat RFCRS01A
SETENV (ORACLE_HOME = "/opt/oracle/product/12.1.0.2")
SETENV (ORACLE_SID='FCRS01A')
AssumeTargetDefs
DiscardFile /opt/gg/bin/12.2.1/dirrpt/rpsb.dsc, purge, megabytes 3
UserIdAlias ggadmin_fcrs01a
--HANDLECOLLISIONS
ALLOWDUPTARGETMAP
GETTRUNCATES
--BATCHSQL
--This fires for everything, but only processes deletes
IGNOREINSERTS
IGNOREUPDATES
GETDELETES
MAP FACETS_CUSTOM.*, TARGET FACETS_CUSTOM.*;
IGNOREINSERTS
IGNOREUPDATES
GETDELETES
MAP FACETS.*, TARGET FACETS.*;
--Fires for everything but only processes inserts
IGNOREDELETES
IGNOREUPDATES
GETINSERTS
MAP FACETS_CUSTOM.*, TARGET FACETS_CUSTOM.*
COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'), INSERT_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'));
IGNOREDELETES
IGNOREUPDATES
GETINSERTS
MAP FACETS.*, TARGET FACETS.*
COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'), INSERT_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'));
--COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@GETENV('JULIANTIMESTAMP'), INSERT_DATE=@GETENV('JULIANTIMESTAMP'));
--COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@DATENOW(), INSERT_DATE=@DATENOW());
--Fires for everything only processes updates.
IGNOREINSERTS
IGNOREDELETES
GETUPDATES
MAP FACETS_CUSTOM.*, TARGET FACETS_CUSTOM.*
COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'));
IGNOREINSERTS
IGNOREDELETES
GETUPDATES
MAP FACETS.*, TARGET FACETS.*
COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'));
--COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@DATENOW());