WARNING OGG-01519

2019-02-14 05:13:09 WARNING OGG-01519 Waiting at EOF on input trail file /home/u01/app/ogg/dirdat/MB000000002,
which is not marked as complete; but succeeding trail file /home/u01/app/ogg/dirdat/MB000000003 exists. If ALTE
R ETROLLOVER has been performed on source extract, ALTER EXTSEQNO must be performed on each corresponding downst
ream reader.

–解决方法:

GGSCI (rst.wonders.oracle) 7> stop lr02

Sending STOP request to REPLICAT LR02 …
Request processed.

GGSCI (rst.wonders.oracle) 8> alter replicat lr02 extseqno 3 extrba 0

2019-02-14 10:29:26 INFO OGG-06594 Replicat LR02 has been altered. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start LR02 with NOFILTERDUPTRANSACTIONS option.

REPLICAT (Integrated) altered.

GGSCI (rst.wonders.oracle) 9> start lr02 NOFILTERDUPTRANSACTIONS

GGSCI (rst.wonders.oracle) 12> view report lr02
2019-02-14 10:29:58 INFO OGG-02232 Switching to next trail file /home/u01/app/ogg/dirdat/MB000000005 at 201
9-02-14 10:29:58.643080 due to EOF. with current RBA 1,474.
Processed extract process graceful restart record at seq 5, rba 1412.

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

参考文档:https://www.cnblogs.com/oracle-ziyuhou/archive/2019/02/14/10373223.html

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值