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

2015-07-16 12:07:34 · 作者: · 浏览: 11
ad 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? ?