OGG版本:11.2.1.0.13
故障描述:
因凌晨数据库实例自动重启,导致ogg抽取进程ABENDED
ogg进程宕掉查看$GGATE_HOME/ggserr.log日志报错内容如下:
ERROR OGG-01028 Detect partial pdata at rba xxxxxx without coinciding crash recovery marker record in log with seqno = xxxxxx
日志报错内容大概为:
错误 OGG-01028 在 rba xxxxxx 处检测部分 pdata,而不与 seqno = xxxxxx 的日志中的崩溃恢复标记记录重合
故障原因:
当经典提取在日志写进程中失败时,存在不完整的提取,会导致抽取进程宕掉
故障处理:
-
尝试重新启动抽取进程,该进程会被启动,一般不会出现任何问题,并将继续处理记录
-
若重启抽取进程失败,在抽取进程中添加以下参数,跳过不完整日志数据,重启抽取进程
tranlogoptions _skipincompletelogdata
参考:Doc ID 1355067.1
- Bug 18643085 - CE repeatedly abends with DETECT PARTIAL PDATA AT RBA error
When classic Extract fails during the log writer process, it can now continue even though there is incomplete
log data- Bug:16865401 - EXTRACT ABEND WITH DETECT INCONSISTENCY IN PDATA WITH PDATA START AT RBA 107497