ITPub博客

首页 > 数据库 > Oracle > ERROR OGG-00730 No minimum supplemental logging is enabled

ERROR OGG-00730 No minimum supplemental logging is enabled

原创 Oracle 作者:linfeng_oracle 时间:2014-06-05 11:05:07 0 删除 编辑

今天ogg 抽取进程abend。

ogg版本:

Version 11.2.1.0.6 16211226 OGGCORE_11.2.1.0.6_PLATFORMS_130418.1829


查看进程报错:

2014-06-05 09:41:39  ERROR   OGG-00730  No minimum supplemental logging is enabled. This may cause extract process to handle key update incorrectly if key column is not
 in first row piece.


查看数据库附加日志:

SQL> select supplemental_log_data_min from v$database;

SUPPLEME
--------
YES


数据库有附加日志,查看metalink发现是ogg bug,只有在特殊的版本才会这样

Applies to:
 Oracle GoldenGate - Version 11.2.1.0.5 to 11.2.1.0.7 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Extract running with a OGG version higher than v11.2.1.0 4 and less than v11.2.1.0.7 abend with the following error

OGG-00730 No minimum supplemental logging is enabled. This may cause extract process to handle key update incorrectly if key column is not in first row piece

Cause

This is due to a regression bug( handled via Bug 16857778)

The ogg v11.2.1.0 4 and lower could process the same archive log without any issues.

Solution


The solution is to use a OGG build which have the Bug 16857778.

The workaround is to

1) use v11.1.x or v11.2.1.0.4(or lower) to process the specified archive log.

Or
2) Use the undocumented parameter " TRANLOGOPTIONS DISABLESUPPLOGCHECK" . Once it bypass the problematic archive log file remove the same.

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

上一篇: ORACLE索引概述
请登录后发表评论 登录
全部评论

注册时间:2011-09-14

  • 博文量
    76
  • 访问量
    415785