HowToEnableArchiveLogModeInaRACEnvironment

APPLIES TO:

Information in this document applies to any platform.

GOAL

How to enable archive log mode In a RAC Environment?

SOLUTION

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

1. Shutdown immediate all database instances:

$ srvctl stop database -d 

2. Startup the database in mount mode:

$ srvctl start database -d -o mount

3. Enable archive logging:

$ sqlplus / as sysdba
sql> alter database archivelog;
sql> exit;

4. Stop the database.

$ srvctl stop database -d 

5. Re-start all database instances:

$ srvctl start database -d 

6. Verify archiving is enabled/disabled by running the following command:

sql> archive log list;

Note: There may be a  need to set your log_archive_dest(_n) parameters to a shared location in each spfile, but the log_archive_start parameter does not need to be set anymore as of 10g (See Note 274302.1) for more details.

 
B. To disable archive logging, follow the same steps above, but use the NOARCHIVELOG clause of the ALTER DATABASE statement.

Please note, from 10.2 onwards, it is no longer required to modify cluster_database parameter to change archive log mode. Please refer to:

Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide
What's New in Oracle Real Application Clusters Administration and Deployment?

"Changing the Archiving Mode

There is no longer a need to modify the CLUSTER_DATABASE parameter setting to change the archiving mode in Oracle RAC. Instead, change archive log mode as long as the database is mounted in the local instance and not open in any instances."

REFERENCES