1.查询是否开启了附加日志
SQL> SELECT supplemental_log_data_min FROM v$database;
SUPPLEME
--------
NO
2.启用附加日志
SQL> alter database add supplemental log data;
Database altered.
3.验证开启
SQL> SELECT supplemental_log_data_min FROM v$database;
SUPPLEME
--------
YES