Here are list of working steps on how we can enable and disable archive log in Oracle RAC database.

To enable ARCHIVE LOG MODE IN RAC =>

Step1: stop database instance on node1 using sqlplus.

[[email protected] bin]# sqlplus /nolog
SQL> select instance_name from v$instance;
TEST1
SQL> shutdown immediate;

Step2: Stop database instance on node2 using sqlplus.

[[email protected] bin]# sqlplus /nolog
SQL> select instance_name from v$instance;
TEST2
SQL> shutdown immediate;

Step3: start only one instance i.e node1.

SQL>startup mount;
SQL>alter database archivelog;
SQL>alter database open;

Step4: Now connect node2 and start the instance only.

[[email protected] bin]# sqlplus /nolog
SQL>startup
SQL> select log_mode from v$database;
SQL>archivelog #it means database is in archive log mode

To Disable ARCHIVE LOG MODE IN RAC =>

Step1: stop database instance on node1 using sqlplus.

[[email protected] bin]# sqlplus /nolog
SQL> select instance_name from v$instance;
TEST1
SQL> shutdown immediate;

Step2: Stop database instance on node2 using sqlplus.

[[email protected] bin]# sqlplus /nolog
SQL> select instance_name from v$instance;
TEST2
SQL> shutdown immediate;

Step3: start only one instance i.e node1.

SQL>startup mount;
SQL>alter database noarchivelog;
SQL>alter database open;

Step 4:Now connect node2 and start the instance only.

[[email protected] bin]# sqlplus /nolog
SQL>startup
SQL> select log_mode from v$database;
SQL>noarchivelog #its showing database is in archivelog mode.