ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ogg extract abend OGG-01573

ogg extract abend OGG-01573

原创 Linux操作系统 作者:春之初 时间:2011-07-12 09:03:15 0 删除 编辑
生产库某个抽取进程每隔一段时间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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/55827/viewspace-701937/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-05-17

  • 博文量
    8
  • 访问量
    29560