ogg，启用DDL同步后，目标端replicate挂起，

最新推荐文章于 2021-04-13 03:19:43 发布

文档搬运工

最新推荐文章于 2021-04-13 03:19:43 发布

阅读量1.3k

点赞数

分类专栏： Stream & OGG

本文链接：https://blog.csdn.net/xxzhaobb/article/details/80595569

版权

Stream & OGG 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

源端 test、RDBMS 11.2.0.4 PSU 11.2.0.4.180417目标端 orcl ，RDMBS 11.2.0.4 ，没有安装PSU 。
在源端 create table bb.object2 as select * from dba_objects;

随后，在目标端，可以看到bb.object2 这个表也生成了。但是数据和目标端是不一样的。

SYS@test>create table bb.object2 as select * from dba_objects;

Table created.

SYS@test>select count(*) from bb.object2;

  COUNT(*)
----------
     87175

1 row selected.


SYS@orcl>select count(*) from bb.object2;

  COUNT(*)
----------
     87092

SYS@orcl>select comments from dba_registry_history;

COMMENTS
--------------------------------------------------------------------------------
Patchset 11.2.0.2.0
Patchset 11.2.0.2.0

SYS@orcl>

SYS@test>select comments from dba_registry_history;

COMMENTS
------------------------------------------------------------------------------------------------------------------------
Patchset 11.2.0.2.0
Patchset 11.2.0.2.0
PSU 11.2.0.4.180116
PSU 11.2.0.4.180417

4 rows selected.

在源端上delete from bb.object2; commit; 源端表中数据全部被删除了。目标端的replcate进行挂了。提示是找不到数据。

2018-06-06 14:08:41  WARNING OGG-01004  Aborted grouped transaction on 'BB.OBJECT1', Database error 1403 (OCI Error ORA-01403: no data found, SQL <DELETE FRO
M "BB"."OBJECT1"  WHERE "OWNER" = :b0 AND "OBJECT_NAME" = :b1 AND "SUBOBJECT_NAME" is NULL AND "OBJECT_ID" = :b3 AND "DATA_OBJECT_ID" = :b4 AND "OBJECT_TYPE"
 = :b5 AND "CREATED" = :b6 AND "LAST_DDL_TIME" = :b7 AND "TIMESTAMP" = :b8 AND "STATUS" = :b9 AND "TEMPORARY" = :b10 AND "GENERATED" = :b11 AND "SECONDARY" =
 :b12 AND "NAMESPACE" = :b13 AND "EDITION_NAME" is NULL AND ROWNUM = 1>).

2018-06-06 14:08:41  WARNING OGG-01003  Repositioning to rba 6420 in seqno 0.

2018-06-06 14:08:41  WARNING OGG-01154  SQL error 1403 mapping BB.OBJECT1 to BB.OBJECT1 OCI Error ORA-01403: no data found, SQL <DELETE FROM "BB"."OBJECT1"
WHERE "OWNER" = :b0 AND "OBJECT_NAME" = :b1 AND "SUBOBJECT_NAME" is NULL AND "OBJECT_ID" = :b3 AND "DATA_OBJECT_ID" = :b4 AND "OBJECT_TYPE" = :b5 AND "CREATE
D" = :b6 AND "LAST_DDL_TIME" = :b7 AND "TIMESTAMP" = :b8 AND "STATUS" = :b9 AND "TEMPORARY" = :b10 AND "GENERATED" = :b11 AND "SECONDARY" = :b12 AND "NAMESPA
CE" = :b13 AND "EDITION_NAME" is NULL AND ROWNUM = 1>.

2018-06-06 14:08:41  WARNING OGG-01003  Repositioning to rba 6420 in seqno 0.

原因分析：

因为源端有87175条数据，目标端有87092条数据，在源端删除数据后，目标端要删除数据，而部分数据在目标端是不存在的。

所以会出现这个问题。

解决方法

在目标端的replicate 参数里面，添加handlecollisions。随后，目标端的replicate进程就可以启动了。表中数据被删除。

END。