How To Enable/Disable Archive Log Mode in Real Application Cluster Environment (Doc ID 235158.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 9.0.1.0 to 10.1.0.5 [Release 9.0.1 to 10.1]
Information in this document applies to any platform.

GOAL

The note is to provide steps to enable/disable archivelog mode in RAC environment.

SOLUTION

1. Shut down all instances.

2. Set the CLUSTER_DATABASE parameter to false on one instance in the parameter
file. If using the server parameter file, make an entry for this:

     *.CLUSTER_DATABASE= False

For Modifying server parameter file (SPFILE):

Alter system set cluster_database=FALSE scope=spfile sid='*';

See Document 137483.1 How to Modify the Content of a SPFILE Parameter File

3. Set the LOG_ARCHIVE_START parameter to true.

4. Set the LOG_ARCHIVE_FORMAT and make sure the parameter containing the %t parameter includes the thread number in the archived logfile name.

5. Set the cluster database wide LOG_ARCHIVE_DEST_1 parameter in the parameter file as follows:

LOG_ARCHIVE_DEST_1='LOCATION=$ORACLE_BASE/oradata/<db_name>/archive'

Note: You can multiplex the destination to up to ten locations, refer to:
Document 66433.1 Oracle8i - Multiple Archive Destinations and Remote Archival

To specify the archive log destinations on a per instance basis for a two-instance cluster database, for example, set the parameter as follows:

   <sid1>.LOG_ARCHIVE_DEST_1='LOCATION=$ORACLE_BASE/oradata/<db_name>/archive'
   <sid2>.LOG_ARCHIVE_DEST_1='LOCATION=$ORACLE_BASE/oradata/<db_name>/archive'

Archive logs can be stored on the shared disk on platforms that support CFS (Cluster File System).  For more information on this see the following note: Document 183408.1   Raw Devices and Cluster Filesystems With Real Application Clusters

6. Mount the database (in exclusive mode) for the instance on which you have set CLUSTER_DATABASE to false.

7. Set the database in ARCHIVELOG mode :
    

     SQL> ALTER DATABASE ARCHIVELOG;

8. Shutdown the instance.

     SQL> SHUTDOWN IMMEDIATE;

9. Change the value of the CLUSTER_DATABASE parameter back to true.

10. Startup all instances.

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