OGG-00730处理经验

报错：

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

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

转载于:http://blog.itpub.net/24695024/viewspace-1470195/