JZTXT

Oracle打开归档、强制、最小附加日志

发布时间 2023-07-25 10:45:03作者: 捌玖

startup mount;

alter database archivelog;

alter database force logging;

alter database add supplemental log data;

alter database add supplemental log data all columns;

SELECT LOG_MODE,FORCE_LOGGING,SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;