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

 

startup mount;

 

alter database archivelog;

alter database force logging;

alter database add supplemental log data;

SELECT  LOG_MODE,FORCE_LOGGING,SUPPLEMENTAL_LOG_DATA_MIN  FROM  V$DATABASE;