Found errors in REPLICAT and caused it stopped.
GGSCI
(target) 1> info all
Program Status Group
Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP1
00:00:13 53:34:02
GGSCI (target) 2> view report REP1
...
2017-05-24 23:12:11 WARNING OGG-00869 OCI Error
ORA-00001: unique constraint (HR.EMPLOYEES_PK) violated (status =
1), SQL <INSERT INTO "HR"."EMPLOYEES" (...) VALUES (...)>.
2017-05-24 23:12:11 WARNING OGG-01004 Aborted grouped
transaction on 'HR.EMPLOYEES', Database error 1 (OCI Error
ORA-00001: unique constraint (HR.EMPLOYEES_PK) violated (status =
1), SQL <INSERT INTO "HR"."EMPLOYEES" (...) VALUES (...)>).
2017-05-24 23:12:11 WARNING OGG-01003 Repositioning to
rba 3495814 in seqno 384.
2017-05-24 23:12:11 WARNING OGG-01154 SQL error 1
mapping HR.EMPLOYEES to HR.EMPLOYEES OCI Error ORA-00001: unique
constraint (HR.EMPLOYEES_PK) violated (status = 1), SQL <INSERT
INTO "HR"."EMPLOYEES" (...) VALUES (...)>.
2017-05-24 23:12:11 WARNING OGG-01003 Repositioning to
rba 3495814 in seqno 384.
...
2017-05-24 23:12:11 ERROR OGG-01296 Error
mapping from HR.EMPLOYEES to HR.EMPLOYEES.
...GGSCI
(target) 3> edit params REP1
--Replicat group --
replicat rep1
--source and target definitions
ASSUMETARGETDEFS
--target database login --
userid ggate, password ggate
--file for dicarded transaction --
discardfile E:\oracle\gg\discard\rep1_discard.txt, append,
megabytes 10
-- Telling REPLICAT to skip ORA-00001 and ORA-01403 in the target
database for avoiding obvious logic conflicts in the future.
reperror (0001, discard)
reperror (1403, discard)
--ddl support
DDL
--Specify table mapping ---
map sender.*, target receiver.*;
GGSCI
(target) 4> start REP1In the above, I told REPLICAT to skip ORA-00001
and ORA-01403 in the target database for avoiding obvious
logic conflicts in the future.
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (target) 5> info all
Program Status Group
Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1
00:00:00 00:00:02