实例名：czmmiao1,czmmiao2

归档路径方案，每个节点上都存有个字的归档日志和对方节点的归档日志，以保证每个节点都有所有的归档日志。

设置步骤

1、在某节点配置归档日志位置

alter system set log_archive_dest_1='location=/u01/app/oracle/product/10.2.0/arch_czmiao1' scope=spfile sid='czmmiao1';
alter system set log_archive_dest_2='service=czmiao1' scope=spfile sid='czmmiao2';
alter system set standby_archive_dest='/u01/app/oracle/product/10.2.0/arch_czmiao2' scope=spfile sid='czmmiao1';
alter system set standby_archive_dest='/u01/app/oracle/product/10.2.0/arch_czmiao1' scope=spfile sid='czmmiao2';
alter system set log_archive_dest_1='location=/u01/app/oracle/product/10.2.0/arch_czmiao2' scope=spfile sid='czmmiao2';
alter system set log_archive_dest_2='service=czmiao2' scope=spfile sid='czmmiao1';

2、修改cluster_database参数

alter system set cluster_database=false scope=spfile sid='*';

3、关闭所有实例

shutdown immediate;

4、把某个实例启动到mount，修改归档模式

startup mount;

alter database archivelog;

alter system set cluster_database=true scope=spfile sid='*';

5、重启数据库确认归档生效

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/product/10.2.0/arch_czmmiao1
Oldest online log sequence     7
Next log sequence to archive   8
Current log sequence           8

6、确认生效位置

alter systemswitch logfile;

参考至:《大话Oracle RAC》张晓明著
本文原创，转载请注明出处、作者
如有错误，欢迎指正
邮箱:czmcj@163.com参考至