Andrew Fraser DBA

RAC alter database archivelog

Switch a RAC database into archivelog mode:

srvctl stop database -d dbname
startup mount    --only one instance
alter database archivelog
alter database open
srvctl start database -d dbname  --this will start the remaining instances on the cluster

And switch it into noarchivelog mode:

srvctl stop database -d dbname
startup mount    --only one instance
alter database noarchivelog
alter database open
srvctl start database -d dbname   --this will start the remaining instances on the cluster

Above method from Bhavin Hingu. It is also possible to do it this way:

alter system set log_archive_dest_1='location=/ORA_DISK/redoarch/arch_' scope=both sid='*' ;
alter system set cluster_database=false scope=spfile sid='mydb1';
srvctl stop database -d mydb
startup mount
alter database archivelog ;
alter system set cluster_database=true scope=spfile sid='mydb1';
shutdown immediate
srvctl start database -d mydb

And switch it into noarchivelog mode:

alter system reset log_archive_dest_1 scope=spfile sid='*' ;
alter system set cluster_database=false scope=spfile sid='mydb1';
srvctl stop database -d mydb
startup mount
alter database noarchivelog ;
alter system set cluster_database=true scope=spfile sid='mydb1';
shutdown immediate
srvctl start database -d mydb