SQL> select supplemental_log_data_min,
2 supplemental_log_data_pk,supplemental_log_data_ui
3 from v$database;

SUPPLEME SUP SUP
-------- --- ---
YES NO NO

YES 表示已经开启最小附加日志了