Convert RAC DB to archive log mode

1. The following steps need to be taken to enable archive logging in a RAC database environment:
[oracle@node1 ~]$ srvctl stop database -d racdp

[oracle@node1 ~]$ srvctl status  database -d racdp

Instance racdp1 is not running on node node1
Instance racdp2 is not running on node node2

-- startup database in mount mode

[oracle@node1 ~]$ srvctl start database -d racdp  -o mount

[oracle@node1 ~]$ srvctl status  database -d racdp
Instance racdp1 is running on node node1
Instance racdp2 is running on node node2

SQl> select distinct name, instance_name ,host_name , log_mode,open_mode,version from gv$database,gv$instance;

NAME   INSTANCE_NAME    HOST_NAME  LOG_MODE   OPEN_MODE    VERSION
--------- ---------------- ----------------------------------- ---------- --------------- ---------- --------------- -----
RACDP   racdp1    node1.localdomain NOARCHIVELOG   MOUNTED          11.2.0.4.0
RACDP   racdp2    node2.localdomain NOARCHIVELOG   MOUNTED       11.2.0.4.0


-- enable archive logging

$ sqlplus / as sysdba
sql> alter database archivelog;

SQL> select distinct name, instance_name ,host_name , log_mode,open_mode,version from gv$database,gv$instance;

NAME   INSTANCE_NAME    HOST_NAME       LOG_MODE        OPEN_MODE       VERSION
--------- ---------------- ----------------------------------- --------------- --------------- -----------------
RACDP   racdp1    node1.localdomain         ARCHIVELOG      MOUNTED        11.2.0.4.0
RACDP   racdp2    node2.localdomain         ARCHIVELOG      MOUNTED        11.2.0.4.0


oracle@node1 ~]$ srvctl stop database -d  racdp

[oracle@node1 ~]$ srvctl status  database -d racdp

Instance racdp1 is not running on node node1
Instance racdp2 is not running on node node2

$ srvctl start database -d  racdp

[oracle@node1 ~]$ srvctl status  database -d racdp
Instance racdp1 is running on node node1
Instance racdp2 is running on node node2

NAME   INSTANCE_NAME    HOST_NAME            LOG_MODE        OPEN_MODE       VERSION
--------- ---------------- ----------------------------------- --------------- --------------- -----------------
RACDP   racdp1    node1.localdomain         ARCHIVELOG      READ WRITE       11.2.0.4.0
RACDP   racdp2    node2.localdomain         ARCHIVELOG      READ WRITE       11.2.0.4.0



SQL> Archive log list;

Database log mode        Archive Mode
Automatic archival        Enabled
Archive destination        USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     2
Next log sequence to archive   3
Current log sequence        3


You might 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

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

From 10.2 onwards, it is no longer required to modify cluster_database parameter to change archive log mode.
You no longer need to modify the CLUSTER_DATABASE parameter setting to change the archiving mode in Oracle RAC. You can change archive log mode as long as the database is mounted in the local instance and not open in any instances."