oracle归档

Oracle分为非归档模式(NOARCHIVELOG) 和归档模式(ARCHIVELOG)

select name,log_mode from v$database;

也可以用下面的语句
archive log list;(该方法需要as sysdba)

10.2G,win10步骤：(目录需要手动创建)

alter system set log_archive_dest_1='location=E:/oracle/product/10.2.0/log/archive_log';
alter system set log_archive_dest_2='location=E:/oracle/product/10.2.0/log/archive2_log';

shutdown immediate

startup mount;

alter database archivelog;

alter database open;

alter system set log_archive_max_processes = 5;

alter system set log_archive_format = "archive_%t_%s_%r.log" scope=spfile;

archive log list;