OGG-00730错误

问题描述：
2011-04-26 19:24:16 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
 
  
开启数据库级supplemental log：
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