重庆思庄Oracle、Redhat认证学习论坛

标题: OGG-02161 Failed to retrieve the trail file begin checkpoint position [打印本页]

作者: 郑全 时间: 2019-5-10 16:58
标题: OGG-02161 Failed to retrieve the trail file begin checkpoint position
使用ogg数据初始化时，如果我们手工去启动初始化的复制进程，

如下：
GGSCI (server2 as ogg@orcl) 63> start rini_1

会报以下错误：
2019-05-10T16:46:28.867+0800  INFO OGG-06604  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  Database ORCL CPU info: CPU Count 4, CPU Core Count 4, CPU Socket Count 2.
2019-05-10T16:46:28.867+0800  WARNING OGG-05673  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  CSN-based duplicate suppression is disabled because there is no checkpoint table for this Replicat.
2019-05-10T16:46:28.867+0800  ERROR OGG-02161  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  Failed to retrieve the trail file begin checkpoint position.
2019-05-10T16:46:28.867+0800  ERROR OGG-01668  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  PROCESS ABENDING.

正确的姿势是，启动源端的初始化抽取进程，会自动启动目标端的初始复制进程。

比如：
源端：

GGSCI (dbserver) 12> start eini_1
Sending START request to MANAGER ...
EXTRACT EINI_1 starting

目标端：
GGSCI (server2 as ogg@orcl) 58> info *,task
REPLICAT RINI_1 Initialized 2019-05-10 16:17 Status RUNNING
Checkpoint Lag    00:00:00 (updated 00:20:13 ago)
Process ID          14340
Log Read Checkpoint  Not Available
Task                SPECIALRUN

并且初始复制完成后，初始复制进程会自动停止，不需要人工干预。
2019-05-10T16:40:05.624+0800  INFO OGG-00993  Oracle GoldenGate Capture for Oracle, eini_1.prm:  EXTRACT EINI_1 started.
2019-05-10T16:40:11.305+0800  INFO OGG-02911  Oracle GoldenGate Capture for Oracle, eini_1.prm:  Processing table SCOTT.DEPT_OGG.
2019-05-10T16:40:13.483+0800  INFO OGG-00991  Oracle GoldenGate Capture for Oracle, eini_1.prm: EXTRACT EINI_1 stopped normally.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)