Hello, I have Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 Real Application Clusters. I want to convert the database from archivelog to noarchivelog mode. Is there any need to change the cluster_database to false (in this release)?
Yes, changing from archivelog to noarchivelog mode requires you to mount the database exclusively from each instance. Prior to 10gR2 you could not do this with the cluster_database parameter set to TRUE. You need to start with the cluster_database parameter set to FALSE, shut down, repeat for each instance and then bring them up with the parameter set to TRUE.
There is no need to change the parameter in 10gR2 as long as you still mount exclusively from one instance.
Now, why you would want to go to noarchive from archive is another question ... :)
Dig deeper on Oracle RAC and database clustering
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.