打开Oracle归档模式

打开Oracle归档模式

sqlplus / as sysdba

shut immediate;
startup nomount;
alter system set LOG_ARCHIVE_DEST_1='LOCATION=/opt/Oracle/fra/archive/1';
alter system set LOG_ARCHIVE_DEST_2='LOCATION=/opt/oracle/fra/archive/2';
alter system set log_archive_format='arch%s.arc' scope=spfile;
alter system set log_archive_start=true scope=spfile;    # 10g开始, 此参数废弃.
startup mount force;
alter database archivelog;    # 关闭归档: alter database noarchive