暂无图片
OGG-01154 ORA-01555: snapshot too old
我来答
分享
pgone
2023-07-24
OGG-01154 ORA-01555: snapshot too old

ogg复制进程报错

2023-07-24 09:00:15 WARNING OGG-00869 OCI Error ORA-01555: snapshot too old: rollback segment number 284 with name "_SYSSMU284_1979019178$" too small (status = 1555), SQL <UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BI_ODS"."EKPO" x SET x."LABNR" = :a10,x."ETL_DT" = :a11,x."UPD_FLAG" = :a12,x."SNAP_DT" = :a13 WHERE x."MANDT" = :b0 AND x."EBELN" = :b1 AND x."EBELP" = :b2>.

2023-07-24 09:00:15 WARNING OGG-01004 Aborted grouped transaction on 'BI_ODS.EKPO', Database error 1555 (OCI Error ORA-01555: snapshot too old: rollback segment number 284 with name "_SYSSMU284_1979019178$" too small (status = 1555), SQL <UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BI_ODS"."EKPO" x SET x."LABNR" = :a10,x."ETL_DT" = :a11,x."UPD_FLAG" = :a12,x."SNAP_DT" = :a13 WHERE x."MANDT" = :b0 AND x."EBELN" = :b1 AND x."EBELP" = :b2>).

2023-07-24 09:00:15 WARNING OGG-01003 Repositioning to rba 215770665 in seqno 588643.

2023-07-24 09:00:15 WARNING OGG-01154 SQL error 1555 mapping SAPSR3.EKPO to BI_ODS.EKPO OCI Error : rollback segment number 284 with name "_SYSSMU284_1979019178$" too small (status = 1555), SQL <UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BI_ODS"."EKPO" x SET x."LABNR" = :a10,x."ETL_DT" = :a11,x."UPD_FLAG" = :a12,x."SNAP_DT" = :a13 WHERE x."MANDT" = :b0 AND x."EBELN" = :b1 AND x."EBELP" = :b2>.

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
Thomas

在该进程的参数里,加入这句:GROUPTRANSOPS 10   再启动该进程试试。

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏