在做OGG时,发现了一个报错,如下:
源库
2020-07-22 12:14:31 WARNING OGG-01194 EXTRACT task RINI_1 abended : There is no trail t
o reposition to when doing direct load task.
2020-07-22 12:14:31 ERROR OGG-01203 EXTRACT abending.
2020-07-22 12:14:31 ERROR OGG-01668 PROCESS ABENDING
目标库
2020-07-22 12:14:30 WARNING OGG-00869 OCI Error ORA-00001: unique constraint (SC
OTT.PK_DEPT) violated (status = 1). INSERT INTO “SCOTT”.“DEPT” (“DEPTNO”,“DNAME”,"
LOC") VALUES (:a0,:a1,:a2).
2020-07-22 12:14:30 WARNING OGG-01004 Aborted grouped transaction on 'SCOTT.DEPT
', Database error 1 (OCI Error ORA-00001: unique constraint (SCOTT.PK_DEPT) violat
ed (status = 1). INSERT INTO “SCOTT”.“DEPT” (“DEPTNO”,“DNAME”,“LOC”) VALUES (:a0,:
a1,:a2)).
2020-07-22 12:14:30 ERROR OGG-01200 There is no trail to reposition to when do
ing direct load task.
报错说时找不到重定位线索。我在做时怀疑时权限不足,或者编写eini时错误。来回检查赋权N编,但是依旧无果。
后来仔细观察,发现是目标库表数据未清空,在用直接加载法来加载初始数据,需要将目标端的所有表数据清空,然后从源端传输数据过去。
目标库
SCOTT@ prod>truncate table emp;
Table truncated.
SCOTT@ prod>truncate table dept;
Table truncated.
GGSCI (cugg88) 66> start eini_1
Sending START request to MANAGER …
EXTRACT EINI_1 starting
GGSCI (cugg88) 67> info eini_1
EXTRACT EINI_1 Last Started 2020-07-22 14:38 Status RUNNING
Checkpoint Lag Not Available
Log Read Checkpoint Table SCOTT.DEPT
2020-07-22 14:38:10 Record 1
Task SOURCEISTABLE
GGSCI (cugg88) 68> info eini_1
EXTRACT EINI_1 Last Started 2020-07-22 14:38 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Table SCOTT.EMP
2020-07-22 14:38:36 Record 14
Task SOURCEISTABLE
源库操作未报错,成功解决。