Re: RAC - NOARCHIVELOG to ARCHIVELOG migration

On Wed, April 26, 2006 23:47, LS Cheng said:
> May I ask why should CLUSTER_DATABASE set to FALSE?

Starting from 10gR2 you actually need not. Just make sure that no other instance has database open. See Chapter 7 of "Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide".

In previous releases (up to 10gR1) there was a requirement to mount database EXCLISIVE in order to change archive mode. Up to 9i that might be done by
SQL> STARTUP MOUNT EXCLUSIVE
without changing any parameter. But in 9i, 10gR1 it is only possible via setting CLUSTER_DATABASE=FALSE.

And thanks for the question! Just one more illustration of how many of consultants get there experience and knowledge ;-)

HTH
- Andrey

--
http://www.freelists.org/webpage/oracle-l