OGG重新应用数据NOFILTERDUPTRANSACTIONS说明

在OGG 12c中,如果把目标端的replicat检查点往tail文件前面调整,默认情况下启动replicat是会自动跳过replicat停止之前事务,如果需要重新应用这些数据,需要在启动replicat时,加上NOFILTERDUPTRANSACTIONS

在修改replicat检查点时有提醒信息,如下:

GGSCI (test1 DBLOGIN as root) 43> alter replicat REP2MY, extseqno 0, extrba 0

2017-03-03 08:27:25  INFO    OGG-06594  Replicat REP2MY has been altered through GGSCI. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start REP2MY with NOFILTERDUPTRANSACTIONS option.

REPLICAT altered.

未加NOFILTERDUPTRANSACTIONS启动replicat,过滤事务的信息如下:

2017-03-03 08:11:44  INFO    OGG-03506  The source database character set, as determined from the trail file, is zhs16gbk.

2017-03-03 08:12:49  INFO    OGG-05663  CSN-based filtering suppressed a duplicate transaction from trail Seqno 0, RBA 0, with CSN 2084867 and transaction ID 4.23.1307.

2017-03-03 08:13:52  INFO    OGG-05663  CSN-based filtering suppressed a duplicate transaction from trail Seqno 0, RBA 0, with CSN 2084991 and transaction ID 10.22.2016.

修改检查点,然后重新应用事务,正确的姿势:

ggsci> alter REPLICAT <rep_name> extseqno <trail sequence #>, extrba <rba within the trail>
ggsci> START REPLICAT <rep_name> NOFILTERDUPTRANSACTIONS

关于紫砂壶

感悟技术人生
此条目发表在GoldenGate分类目录,贴了标签。将固定链接加入收藏夹。