Observed as the Replicat on the target was abended, the first step is to review the replicat report. From the log, the replicat was abended due to “OGG-01154 SQL error 1403 mapping GGADMIN.STUDENT to GGADMIN.STUDENT No data found.”
The table STUDENT was added to the extract, data pump, and replicat but forgot to enable supplemental logging on this table.
2021-06-11 23:30:08 INFO OGG-06510 Using the following key columns for target table GGADMIN.EXCEPTIONS: LOGRBA, LOGPOSITION, COMMITTIMESTAMP.
2021-06-11 23:30:08 INFO OGG-06074 Unique constraint columns used in dependency calculation for table GGADMIN.EXCEPTIONS: LOGRBA, LOGPOSITION, COMMITTIMESTAMP.
2021-06-11 23:30:08 WARNING OGG-01154 SQL error 1403 mapping GGADMIN.STUDENT to GGADMIN.STUDENT No data found.
2021-06-11 23:30:08 WARNING OGG-01004 Aborted grouped transaction on GGADMIN.EXCEPTIONS, Database error 1 (OCI Error ORA-00001: unique constraint (GGADMIN.EXCEPTIONS_PK) violated (statu
s = 1), SQL <INSERT INTO "GGADMIN"."EXCEPTIONS" ("REP_NAME","TABLE_NAME","ERRNO","DBERRMSG","OPTYPE","ERRTYPE","LOGRBA","LOGPOSITION","COMMITTIMESTAMP","GGS_FILENAME","CDRFAIL","CDRSUC","
CDRDETECT") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12)>).
2021-06-11 23:30:08 WARNING OGG-01003 Repositioning to rba 2027 in seqno 5.
2021-06-11 23:30:08 WARNING OGG-01154 SQL error 1403 mapping GGADMIN.STUDENT to GGADMIN.STUDENT No data found.
To fix the issue, follow the below procedures.
1. Enable Supplemental Logging GGSCI (ORA-X2) 4> add trandata GGADMIN.STUDENT
2. Alter replicat to start now. GGSCI (ORA-X2) 4> alter inrep1 begin now; 2021-06-12 10:24:34 INFO OGG-06594 Replicat INREP1 has been altered. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start INREP1 with NOFILTERDUPTRANSACTIONS option. REPLICAT (Integrated) altered.
GGSCI (ORA-X2) 5> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING INEXT2 00:00:00 00:00:07 EXTRACT RUNNING PMP2 00:00:00 00:00:00 REPLICAT STOPPED INREP1 00:00:00 00:00:03 REPLICAT STOPPED REP1 00:00:00 23:28:10
3. Start the Replicat process GGSCI (ORA-X2) 7> start inrep1 Sending START request to MANAGER ... REPLICAT INREP1 starting
GGSCI (ORA-X2) 8> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING INEXT2 00:00:02 00:00:00 EXTRACT RUNNING PMP2 00:00:00 00:00:02 REPLICAT RUNNING INREP1 00:00:00 00:00:25 REPLICAT STOPPED REP1 00:00:00 23:28:33
