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
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/35489/viewspace-706307/ ,如需转载,请注明出处,否则将追究法律责任。