OGG-01172 exceeded max bytes (-1294967296)

gangade

jieyancai 发表于 2017-3-8 16:13
你查查表记录是不是不一致啊？update找不到记录嘛

不好意思，这两天其它事情比较多。看了一下两表信息：10分钟前，两表相差53条记录：


  1  select id from us_mbadmin_yun.t_svr_myservice          -- 源端表
  2  minus
  3* select id from us_mbadmin_yun.t_svr_myservice@to_126    ---目标端表
SQL> /

ID
------------------------------
1489024085258580043
1489024190707766280
1489024190710596619
1489024190714300454
1489024190717657049
1489024190721481210
1489024190724307378
1489024190728113760
1489024190731378281
1489024190734402166
1489024440025629085
1489024663991492717
1489024663994267315
1489024663998111184
1489024664001348673
1489024664005455885
1489024664012685333
1489024664015657221
1489024664019254826
1489024664022855650
1489024664026372160
1489024767607400252
1489026276849417907
1489026276862318091
1489026276873443365
1489026276884337297
1489026276897686305
1489026276908921134
1489026277110626063
1489026277182366953
1489026277195832824
1489026277205179415
1489026380841245645
1489026380845965514
1489026380848129319
1489026380851528418
1489026380855360211
1489026380858820456
1489026380861283272
1489026380864740754
1489026380867392541
1489026380870112813
1489027035436728668
1489027035439730961
1489027035443317664
1489027035446339238
1489027035451257440
1489027035455272554
1489027035458822671
1489027035462406726
1489027035465217687
1489027035469865450
1489030022957901579

53 rows selected.

昨天看了一篇帖子和这问题类似：http://blog.itpub.net/29047826/viewspace-1480526/
但是repl.dsc报错中，红色部分并没有具体数值，从而无法按照帖子的方法insert进去缺少的记录。
repl.dsc报错：

Current time: 2017-03-09 12:53:05

OCI Error ORA-01403: no data found, SQL <UPDATE "US_MBADMIN_YUN"."T_SVR_MYSERVICE" SET "STATUS" = :a1 WHERE "ID" = :b0>
Operation failed at seqno 181 rba 38289458
Discarding record on action DISCARD on error 1403
Problem replicating US_MBADMIN_YUN.T_SVR_MYSERVICE to US_MBADMIN_YUN.T_SVR_MYSERVICE
Record not found
Mapping problem with compressed update record (target format)...
*
ID =
STATUS = 1
*
Process Abending : 2017-03-09 12:53:05

gangade

gangade 发表于 2017-3-9 14:10
不好意思，这两天其它事情比较多。看了一下两表信息：10分钟前，两表相差53条记录：

不一致很正常啊，因为我的repl进程总是在abending，我把repl.dsc删除，重新启动复制进程后，复制进程能running一会，但随后abending，

gangade

jieyancai 发表于 2017-3-8 16:13
你查查表记录是不是不一致啊？update找不到记录嘛

公司杂事太多，弄得时间都是断断续续的！查了一下，两边记录确实不一致（原因可以理解，毕竟复制进程一直挂起，没有同步完导致的），远端比目标端多53条记录

  1  select id from us_mbadmin_yun.t_svr_myservice    --源端表数据查询
  2  minus
  3* select id from us_mbadmin_yun.t_svr_myservice@to_126   --目标端表数据查询
SQL>

SQL> /

ID
------------------------------
1489024085258580043
1489024190707766280
1489024190710596619
1489024190714300454
1489024190717657049
1489024190721481210
1489024190724307378
1489024190728113760
1489024190731378281
1489024190734402166
1489024440025629085
1489024663991492717
1489024663994267315
1489024663998111184
1489024664001348673
1489024664005455885
1489024664012685333
1489024664015657221
1489024664019254826
1489024664022855650
1489024664026372160
1489024767607400252
1489026276849417907
1489026276862318091
1489026276873443365
1489026276884337297
1489026276897686305
1489026276908921134
1489026277110626063
1489026277182366953
1489026277195832824
1489026277205179415
1489026380841245645
1489026380845965514
1489026380848129319
1489026380851528418
1489026380855360211
1489026380858820456
1489026380861283272
1489026380864740754
1489026380867392541
1489026380870112813
1489027035436728668
1489027035439730961
1489027035443317664
1489027035446339238
1489027035451257440
1489027035455272554
1489027035458822671
1489027035462406726
1489027035465217687
1489027035469865450
1489030022957901579

53 rows selected.

下午重新删除repl.dsc文件，重启了复制进程，短暂的running后，有abending了。
看了一篇帖子，http://blog.itpub.net/29047826/viewspace-1480526/
问题和这个类似，也是两表不一致，主要是目标端表确少数据，方法是把repl.dsc报错的id=xxxxx数据通过dblink发送到目标端。
但是我的repl.dsc报错中，id为空，就不知道怎么解决了
repl.dsc报错如下：
Current time: 2017-03-09 12:53:05

OCI Error ORA-01403: no data found, SQL <UPDATE "US_MBADMIN_YUN"."T_SVR_MYSERVICE" SET "STATUS" = :a1 WHERE "ID" = :b0>
Operation failed at seqno 181 rba 38289458
Discarding record on action DISCARD on error 1403
Problem replicating US_MBADMIN_YUN.T_SVR_MYSERVICE to US_MBADMIN_YUN.T_SVR_MYSERVICE
Record not found
Mapping problem with compressed update record (target format)...
*
ID =
STATUS = 1
*
Process Abending : 2017-03-09 12:53:05

gangade

jieyancai 发表于 2017-3-8 16:13
你查查表记录是不是不一致啊？update找不到记录嘛

算是结贴吧！晚上无奈，只能尝试在目标端drop掉该表，同时在源端的抽取和投递进程中添加过滤该表的参数table exclude us_mbadmin_yun.t_svr_myservice  ,然后重启目标端复制进程，总是报错：2017-03-09 22:53:55  ERROR   OGG-00199  Table US_MBADMIN_YUN.T_SVR_MYSERVICE does not exist in target database.

最后在目标端重新定义该表后才启动成功，个人认为是源端配置文件中有这个表的参数，目标端就要有这个表。还要一直观察

tnan1986

reperror (1403, discard)或者reperror (1403, ignore)都可以，dsc文件满可以写个定时任务自动分割文件或者重命名文件