生产库某个抽取进程每隔一段时间abend一次，view report信息每次都一样
如下：
2011-07-12 00:30:30 WARNING OGG-01573 br_validate_bcp: failed in call to: ggcrc64valid.
2011-07-12 00:30:30 WARNING OGG-01573 br_validate_bcp: failed in call to: br_validate_bcp.
2011-07-12 00:30:30 INFO OGG-01639 BOUNDED RECOVERY: ACTIVE: for object pool 1: p20909_Redo Thread 1.
2011-07-12 00:30:30 INFO OGG-01640 BOUNDED RECOVERY: recovery start XID: 83.34.338077.
2011-07-12 00:30:30 INFO OGG-01641 BOUNDED RECOVERY: recovery start position: SeqNo: 2652, RBA: 166558224, SCN: 2361.2464989325 (10142882775181), Timestamp: 2011-07-11 08:39:16.000000.
2011-07-12 00:30:30 INFO OGG-01642 BOUNDED RECOVERY: recovery end position: SeqNo: 2652, RBA: 166802588, SCN: 2361.2464990008 (10142882775864), Timestamp: 2011-07-11 08:39:16.000000.
2011-07-12 00:30:30 INFO OGG-01643 BOUNDED RECOVERY: CANCELED: for object pool 1: p20909_Redo Thread 1.
2011-07-12 00:30:30 INFO OGG-01639 BOUNDED RECOVERY: ACTIVE: for object pool 2: p20909_Redo Thread 2.
2011-07-12 00:30:30 INFO OGG-01640 BOUNDED RECOVERY: recovery start XID: 75.6.343126.
2011-07-12 00:30:30 INFO OGG-01641 BOUNDED RECOVERY: recovery start position: SeqNo: 4837, RBA: 1045992976, SCN: 2361.2464884380 (10142882670236), Timestamp: 2011-07-11 08:37:59.000000.
2011-07-12 00:30:30 INFO OGG-01642 BOUNDED RECOVERY: recovery end position: SeqNo: 4838, RBA: 200727040, SCN: 2361.2464990047 (10142882775903), Timestamp: 2011-07-11 08:39:16.000000.
2011-07-12 00:30:30 INFO OGG-01643 BOUNDED RECOVERY: CANCELED: for object pool 2: p20909_Redo Thread 2.
2011-07-12 00:30:30 INFO OGG-01579 BOUNDED RECOVERY: VALID BCP: CP.EXT_EPME.000000686.
2011-07-12 00:30:30 INFO OGG-01629 BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <>.
查询了metalink，有相关的描述，Extract Abends With Bounded Recovery Errors In The Report File [ID 1293772.1]
Cause
Under these conditions, this may be a problem with the Bounded Recovery Checkpoint file. It is likely corrupted.
Solution
The solution is to reset the Bounded Recovery Checkpoint file when restarting the extract like:
GGSCI> start BRRESET
GGSCI> start
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/55827/viewspace-701937/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
