归档
dba
archive log list; | select log_mode from v$database; #noarachivelog
shutdown immediate;
startup mount;
alter system set log_archive_dest_1='location=/archive';
show parameter log_archive_dest_1
alter database archivelog [noarchivelog#关]
alter database open;
archive log list; | select log_mode from v$database;
alter system switch logfile;
强制日志
select FORCE_LOGGING from v$database;
alter database force logging;
附加日志
select SUPPLEMENTAL_LOG_DATA_MIN from v$database;
alter database add supplemental log data ;