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

 

请使用浏览器的分享功能分享到微信等