产品环境,shareplex复制报错,查看log:
Info 2014-12-08 09:48:00.565477 8102 499754752 Poster exited with code=1, pid = 28650 (posting from aaaaa_splex, queue aaaa_bbbb, to bbbb_splex)
Error 2014-12-08 09:48:00.540231 28650 1879045888 s:2 Poster: Unexpected Oracle error: ORA-01458: invalid length inside variable character string. (object name: "AAA"."AAAAAAAAAAAAAAAAAAA") (posting from aaaaa_splex, queue aaaa_bbbb, to bbbb_splex) [module opo]
Notice 2014-12-08 09:48:00.537308 28650 1879045888 s:2 Poster: ORA-01458: invalid length inside variable character string. (posting from aaaaa_splex, queue aaaa_bbbb, to bbbb_splex) [module osp]
查看两边的表结构,一致。
处理方法:
1. source端,查询AAAAAAA的object_id,比如:111111
2. post端,
set param sp_opo_disable_object_num 111111
stop post
start post
===正常之后
reset param SP_OPO_DISABLE_OBJECT_NUM
stop post
start post
丢的数据,到log目录下面能找到。里面有详细信息。