11g R2 RAC 环境下开启归档模式的方法

方法一

首先来看一下官方的文档：

How To Enable Archive Logging In RAC Environment [ID 1186764.1]	转到底部	
修改时间:2011-6-2类型:HOWTO状态:PUBLISHED优先级:3	注释 (0)				
In this Document
  Goal
  Solution
  References

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.2 - Release: 10.1 to 11.2
Information in this document applies to any platform.
Goal
How to enable database archivelog in RAC configuration?

Solution
The following steps need to be taken to enable archive logging in a RAC database environment:

-- shutdown immediate all database instances
$ srvctl stop database -d <db_unique_name>

-- startup database in mount mode
$ srvctl start database -d <db_unique_name> -o mount

-- enable archvive logging
$ sqlplus / as sysdba
sql> alter database archivelog;
sql> exit;

-- stop database
$ srvctl stop database -d <db_unique_name>

-- restart all database instances