oracle RAC归档模式切换

NO.10 RAC环境下更改归档模式

在RAC环境下更改归档模式不像单机环境下那么简单，今天尝试了一下，记录下来

试验环境：oracle 10gR2 redhat as 5.4，两节点

更改参数

SQL>alter system set log_archive_dest_1='location=+RAC_DISK' sid='RACDB1';
alter system set log_archve_dest_1='location=/arch' scope=spfile;

System altered

SQL> alter system set log_archive_dest_1='location=+RAC_DISK' sid='RACDB2';

System altered

SQL> alter system set db_recovery_file_dest_size=100G;

System altered

SQL> alter system set db_recovery_file_dest='+RAC_DISK';

System altered

关闭一个节点，在另一个节点操作

node1-> srvctl stop instance -d racdb -i racdb1

node2-> srvctl stop instance -d racdb -i racdb2

node1-> sqlplus /nolog

归档改为非归档

SQL>connect / as sysdba
SQL>shutdown immediate;
SQL>startup mount
SQL>alter database noarchivelog;
SQL>alter database open;

非归档改为归档

SQL>connect / as sydba

SQL>startup mount

SQL>alter database archivelog;

SQL>alter database flashback on;

SQL> select name,log_mode,flashback_on from v$database;

NAME      LOG_MODE     FLASHBACK_ON

------------------------------------

RACDB     ARCHIVELOG   YES

SQL> alter database open;

Database altered.