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.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
Now, why you would want to go to noarchive from archive is another question ... :)