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/，如需轉載，請註明出處，否則將追究法律責任。