方法一
首先来看一下官方的文档:
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