Error:
2017-12-27 22:51:11 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 started.
2017-12-27 22:51:11 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle, rep1.prm: NLS_LANG character set AL32UTF8 on the target is different from the source database character set WE8MSWIN1252. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.
2017-12-27 22:51:11 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep1.prm: OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0.
2017-12-27 22:51:11 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rep1.prm: Aborted grouped transaction on 'DA.PMSET_TN', Database error 2291 (OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0).
2017-12-27 22:51:11 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep1.prm: Repositioning to rba 68690185 in seqno 42.
2017-12-27 22:51:11 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rep1.prm: SQL error 2291 mapping DA.PMSET_TN to DA.PMSET_TN OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0.
2017-12-27 22:51:11 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep1.prm: Repositioning to rba 68690185 in seqno 42.
2017-12-27 22:51:11 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, rep1.prm: Error mapping from DA.PMSET_TN to DA.PMSET_TN.
2017-12-27 22:51:11 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.
Fix:
GGSCI (oracledbprod-ro) 10> alter replicat rep1 begin now
REPLICAT altered.
GGSCI (oracledbprod-ro) 11> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
REPLICAT STOPPED REP1 00:00:00 00:00:02
GGSCI (oracledbprod-ro) 12> start manager
Manager started.
GGSCI (oracledbprod-ro) 13> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:09
2017-12-27 22:51:11 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 started.
2017-12-27 22:51:11 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle, rep1.prm: NLS_LANG character set AL32UTF8 on the target is different from the source database character set WE8MSWIN1252. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.
2017-12-27 22:51:11 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep1.prm: OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0.
2017-12-27 22:51:11 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rep1.prm: Aborted grouped transaction on 'DA.PMSET_TN', Database error 2291 (OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0).
2017-12-27 22:51:11 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep1.prm: Repositioning to rba 68690185 in seqno 42.
2017-12-27 22:51:11 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rep1.prm: SQL error 2291 mapping DA.PMSET_TN to DA.PMSET_TN OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0.
2017-12-27 22:51:11 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep1.prm: Repositioning to rba 68690185 in seqno 42.
2017-12-27 22:51:11 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, rep1.prm: Error mapping from DA.PMSET_TN to DA.PMSET_TN.
2017-12-27 22:51:11 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.
Fix:
GGSCI (oracledbprod-ro) 10> alter replicat rep1 begin now
REPLICAT altered.
GGSCI (oracledbprod-ro) 11> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
REPLICAT STOPPED REP1 00:00:00 00:00:02
GGSCI (oracledbprod-ro) 12> start manager
Manager started.
GGSCI (oracledbprod-ro) 13> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:09
ok, you're not concerned about missing transactions?
ReplyDelete