添加附加日志

一、查看

select SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI,SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALL from v$database;
二、开启最小

alter database add supplemental log data;
三、开启其他

alter database add supplemental log data(all,primary key,unique,foreign key) columns;