Change Archive log mode of RAC database

            

                Change Archive log mode of RAC database

1.  Change the cluster database parameter so the database can be mounted in exclusive mode which is required to enable archive logging

alter system set cluster_database=false scope=spfile;

*If using pfile then edit the parameter in the pfile

2. Shutdown the database using srvctl

srvctl stop database -d TEST1

3. Startup one of the instances upto the mount state

sqlplus / as sysdba

startup mount

4. Enable archivelog mode

alter database archivelog;

5. Change the cluster_database parameter back to true in the spfile (or pfile manually)

alter system set cluster_database=true scope=spfile;

6. Shutdown the instance

shutdown immediate

7. Startup the database using srvctl

srvctl start database -d TEST

8. Verify the change

sqlplus / as sysdba

archive log list

For example:

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /testqa/test/
Oldest online log sequence     1
Next log sequence to archive   3
Current log sequence           3