报错:
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.
发现数据库不是最细log模式,查看:
SQL> select supplemental_log_data_min from v$database;
SUPPLEME
NO
修正:
SQL> alter database add supplemental log data;
Database altered.
SQL> alter system switch logfile;
System altered.
重启extract又错:
ERROR OGG-00717 Found unsupported in-memory undo record in sequence 20, at RBA 1137168,
with SCN 0.1181993 (1181993) … Minimum supplemental logging must be enabled to prevent data loss.
解决: 重新alter extract extb1, tranlog, begin now
(2)
查看数据库附加日志:
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
- 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/24695024/viewspace-1470195/
http://blog.itpub.net/24996904/viewspace-1176069/