Switching RAC database to noarchivelog mode
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 ... :)
Thanks,
Bill
This was first published in January 2007
Join the conversationComment
Share
Comments
Results
Contribute to the conversation