使用logmnr分析日志，查找v$logmnr_contents表，发现不到对表的insert ,update记录，后来才知道原来是Supplemental logging is turned off。

SQL> select supplemental_log_data_pk, supplemental_log_data_ui from v$database;

SUPPLEMENTAL_LOG_DATA_PK SUPPLEMENTAL_LOG_DATA_UI
------------------------ ------------------------
NO NO

对数据库作如下修改：

SQL> alter database add supplemental log data (primary key, unique index) columns;

Database altered

SQL> select supplemental_log_data_pk, supplemental_log_data_ui from v$database;

SUPPLEMENTAL_LOG_DATA_PK SUPPLEMENTAL_LOG_DATA_UI
------------------------ -----------------------
YES YES