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)?

    Requires Free Membership to View

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

    All fields are required. Comments will appear at the bottom of the article.