Set Oracle 11Gr2 RAC archive Mode

After the database is created, it is not in archive mode by default. To use RMAN for hot backup, you need to manually switch the database to archive mode. Generally, switching the archive mode is performed when the database is in the mount exclusive state.
The special feature of RAC is that the archive mode cannot be started in the mount exclusive mode in the RAC environment. The CLUSTER_DATABASE parameter must be disabled first, and the CLUSTER_DATABASE parameter must be enabled after the database is modified to the archive mode.
We recommend that you perform the following operations on the server:
$ Sqlplus/nolog
SQL> conn/as sysdba
1) on node 1, set cluster_database to false.
SQL> alter system set cluster_database = false scope = spfile;
2) on node 1, modify the default archive parameters. The following three parameters must be modified:
SQL> alter system set log_archive_format = 'ora92% t _ % s _ % r. log' scope = spfile;
SQL> alter system set log_archive_start = TRUE scope = spfile;
SQL> alter system set log_archive_dest_1 = 'file path' scope = spfile;
3) Stop all node Databases
SQL> shutdown immediate;
4) Start the database in mount mode on node 1.
SQL> startup mount;
5) on node 1, change the database to archivelog mode.
SQL> alter database archivelog;
6) Open the database on node 1.
SQL> alter database open;
7) on node 1, set cluster_database to true.
SQL> alter system set cluster_database = true scope = spfile;
8) Stop the database on node 1.
SQL> shutdown immediate;
9) Start all node databases normally
SQL> startup;
10) check whether the database is archivelog mode.
SQL> archive log list;
Database log mode Archive Mode
If the first line of the displayed result is as shown above, it indicates that it is an archivelog mode.

Author: "FJXSUNMIT"