10g , 11g RAC 環境下開啟歸檔模式的方法

10g R1  要修改cluster_database引數  ，10G R2和以後的版本就不需要了 

 

例子(10g R1或之前)：  

srvctl stop database -d RACDB

節點1
sql>startup mount
sql>alter system set log_archive_dest_1='LOCATION=/opt/arch' scope=spfile sid='RACDB1';
sql>alter system set log_archive_dest_1='LOCATION=/opt/arch' scope=spfile sid='RACDB2';
sql>alter system set cluster_database=false scope=spfile;
sql>shutdown immediate
sql>startup mount
sql>alter database archivelog
sql>alter database open
sql>alter system set cluster_database=true scope=spfile;
sql>shutdown immediate

srvctl start database -d RACDB

 

例子(10g R2或之後)：   

節點1
SQL> alter system set log_archive_dest_1='location=/opt/arch' sid='RACDB1';
SQL> alter system set log_archive_dest_1='location=/opt/arch' sid='RACDB2';

srvctl stop database -d RACDB

節點1
SQL> startup mount
SQL> alter database archivelog;


srvctl start database -d RACDB