OGG目的端的checkpoint table被drop的修复方法(3)

REPLICAT  REPFULL  Last Started 2015-06-11 08:30  Status ABENDED
Checkpoint Lag      00:00:00 (updated 00:33:01 ago)
Log Read Checkpoint  File /u02/ggs/dirdat/td000001 ---->1
                    First Record  RBA 1192        ---->1192

5.修改检查点(其实不叫修改,就是重复一下而已)

GGSCI (localhost.localdomain) 17> alter replicat repfull, extseqno 1, extrba 1192
REPLICAT altered.


GGSCI (localhost.localdomain) 18> info repfull

REPLICAT  REPFULL  Initialized  2015-06-11 09:05  Status STOPPED
Checkpoint Lag      00:00:00 (updated 00:00:04 ago)
Log Read Checkpoint  File /u02/ggs/dirdat/td000001
                    First Record  RBA 1192

6.启动repfull进程,

GGSCI (localhost.localdomain) 19> start repfull

Sending START request to MANAGER ...
REPLICAT REPFULL starting

注意,此时goldengate.ckptfull表里边才被插入一条记录。

7.检查状态:

GGSCI (localhost.localdomain) 41> info all

Program    Status      Group      Lag at Chkpt  Time Since Chkpt

MANAGER    RUNNING                                         
REPLICAT    RUNNING    REPFULL    00:00:00      00:00:01   

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/fd7b4b7e424380a6323a3b1d386ca384.html