converting RAC archive log mode to non archive log mode.


( Note All these steps are just indicative , run these on your test environment , before production )

- shutdown all instance except one

- restart your one instance in mount state which you have left in read - write mode on which you are going to
  perform this

- alter system set cluster_database=false scope=spfile sid='*';

- shutdown immediate

- startup mount;
 
- alter database noarchivelog;

- alter system set log_archive_dest='' scope=spfile sid='*';
 
- alter system set cluster_database=true scope=spfile sid='*' ;

- Startup all instances

Comments

Popular posts from this blog

Installing DBMS_JAVA package in Oracle and calling UTL_DBWS web services through Oracle database

Starting background process GTX4 and GLOBAL_TXN_PROCESSES

upgrade database oracle 10g to oracle 11g