How to change database Mode from "Non Archive" to "Archive" in RAC
High-Level Steps to change database Mode from "Non-Archive" to "Archive" in RAC 1) Cluster_database=false 2) Stop the cluster database 3) Startup the database from one instance in mount stage 4) Change the database mode to archive mode 5) Cluster_database=true 6) Shut down the database 7) Start the cluster database Step by Step Example : - Step 1) Set Cluster_database=false SQL> alter system set cluster_database=false scope=spfile sid='*'; System altered. Step 2) Stop the Cluster database through SRVCTL command [oracle@rac1 dbs]$ srvctl stop database -d karan [oracle@rac1 dbs]$ Step 3) Start the database from one instance in mount stage SQL> startup mount; ORACLE instance started. Total System Global Area 1235959808 bytes Fixed Size 2252784 bytes Variable Size 788529168 bytes Database Buffers 436207616 bytes Redo Buffers 8970240 bytes Database mounte