[重庆思庄每日技术分享]-ORACLE 11G以上版本开启追加日志的命令

alter database add supplemental log data;

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

然后,通过一下命令去查询是否开启:

select supplemental_log_data_min,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI

from v$database;

SUPPLEME SUP SUP

-------- --- ---

YES      YES YES