RAC下归档非归档的切换和单实例也是一样的，都是在MOUNT模式下执行ALTER DATABASE ARCHIVELOG/NOARCHIVELOG;命令。 不同的是：RAC环境下所有实例都必须处于非OPEN状态，然后在任意一个处于MOUNT状态的实例执行ALTER DATABASE命令，操作成功后，再正常启动其它实例即可。
1.切换成归档
1）查看归档状态
sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Sun Feb 16 16:10:50 2014
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /opt/app/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence 1
Current log sequence 2
2）修改归档的默认路径：
在oralce 用户下创建 arch
分别在节点 1 和节点2上创建
mkdir /opt/app/arch
3）查看 archive 路径设置
SQL> show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
4）设置archive log 路径
SQL> alter system set log_archive_dest_1='location=/opt/app/arch' sid='rac1';
System altered.
SQL> alter system set log_archive_dest_1='location=/opt/app/arch' sid='rac2';
System altered.
SQL> show parameter log_archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string location=/opt/app/arch
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
5)切换归档模式：
shutdown immediate
分别在两个节点上执行
然后 startup mount
也要在两边执行
在一个节点执行SQL> alter database archivelog;
Database altered.
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE;
System altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/app/arch
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2
在另外一个节点上查看
SQL> alter database open
2 ;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/app/arch
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1
6）切换成非归档
在一台主机上执行：
SQL>ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE;
在两台主机上执行：
SQL>shutdown immediate;
在一台主机上执行：
SQL>startup mount;
SQL>alter database noarchivelog;
SQL>ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE;
SQL>shutdown immediate;
在两台主机上执行：
SQL>STARTUP
阅读(376) | 评论(0) | 转发(0) |
