在添加新Ogg新链路时，
add replicat rep_3h, exttrail ./dirdat/3h CHECKPOINTTABLE ggm.checkpoint
添加错了
CHECKPOINTTABLE，将ggm.checkpoint添加为goldengate.ckptfull 弄了好一会才找到办法。
此时delete
replicat rep_3h 会抱错：
GGSCI (db02) 19> delete rep_3h
ERROR: Could not delete DB checkpoint for REPLICAT REP_3H (OCI Error ORA-00942: table or view does not exist
(status = 942). Deleting from checkpoint table system.chkpt, group 'REP_3H', key 3271872065
(0xc304ce41), SQL ).
只能：先将加错的CHECKPOINTTABLE 加上，再删除
ADD CHECKPOINTTABLE goldengate.ckptfull
再删除
rep_3h 然后再
add replicat rep_3h, exttrail ./dirdat/3h CHECKPOINTTABLE ggm.checkpoint
成功！
阅读(8098) | 评论(0) | 转发(0) |
