Oracle Database Discussions

Hi,

I am trying to switch off the archive log on our test databases due to space issues frequently. There are 3 databases on RAC in 2 node cluster, out of three databases
2 databases are using spfile and one is using pfile. I am trying to do the following steps in order to switch off the log and I would really appreciate if someone could please tell me if the following steps are OK or if I am missing any info.

Thanks.

=== RAC and Instance with SPFILE==

on instance1
sqlplus ' / as sysdba'
alter system set cluster_database=false scope=spfile sid='test1';
alter system set log_archive_start=false scope=spfile sid='test1';
shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
alter system set cluster_database=true scope=spfile sid='test1';
shutdown immediate;
startup

on instance2
sqlplus ' / as sysdba'
alter system set cluster_database=false scope=spfile sid='test2';
alter system set log_archive_start=false scope=spfile sid='test2';
shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
alter system set cluster_database=true scope=spfile sid='test2';
shutdown immediate;
startup
===============================================

===RAC and Instance with PFILE===

on instance 1
change the parameter log_archive_start=false in initorcl1.ora
change the parameter cluster_database=false in initorcl1.ora

sqlplus ' / as sysdba'
shutdown immediate
startup mount pfile='?/dbs/initorcl1.ora'
Alter database noarchivelog;
shutdown immediate
change the parameter cluster_database=true in initorcl1.ora
sqlplus ' / as sysdba'
startup

on instance 2
change the parameter log_archive_start=false in initorcl2.ora
change the parameter cluster_database=false in initorcl2.ora

sqlplus ' / as sysdba'
shutdown immediate
startup mount pfile='?/dbs/initorcl2.ora'
Alter database noarchivelog;
shutdown immediate
change the parameter cluster_database=true in initorcl2.ora
sqlplus ' / as sysdba'
startup
================================================