$mkdir /oracle/archive1 --假设创建两个归档目的地

$mkdir /oracle/archive2

SQL>connect / as sysdba

SQL>alter system set log_archive_dest_1 = 'location=/oracle/archive1/' scope=spfile;

SQL>alter sytem set log_archive_dest_2 ='location=/oracle/archive2/' scope=spfile;

SQL>alter system set log_archive_format ='arch_%d_%t_%r_%s.log' scope=spfile;

SQL>shutdown immediate;

SQL>startup monut;

SQL>alter database archivelog;

SQL>altetr database open;

SQL>selec log_mode from v$database; --查看是否为archive模式

SQL>select archiver from v$instance; --查看archiver是否处于运行状态

SQL>alter system switch logfile; --将归档日志写至两个目的地

SQL>select name from v$archived_log; --确认存在两个日志目的地

[@more@]

ITPub博客

转至archivelog模式