Oracle RAC on Archive Log Mode

RAC in archive log mode
Enable Archive Log Mode in Oracle RAC 10g Database
Oracle RAC on Archive Log Mode



1- Login to one of the clustered database nodes and change parameter cluster_database to false:


sqlplus / as sysdba

alter system set cluster_database=false scope=spfile sid='rac1'


2- Stop all database instances:

srvctl stop database -d racdb


3- startup mount the instance and enable archivelog mode:

sqlplus / as sysdba

startup mount;

alter database archivelog;


4- Shutdown the previous running Instance and set cluster_database

sqlplus / as sysdba

alter system set cluster_database=true scope=spfile sid='rac1' ; -----<<<<<<<--- Imp

shutdown immediate;



5- Start all instance back:

srvctl start database -d racdb

To check the mode:

sqlplus / as sysdba

archive log list;

or

select log_mode from v$database;