Ask the Expert

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: