ERROR OGG-00730 No minimum supplemental logging is enabled

今天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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24996904/viewspace-1176069/