Re: RAC - NOARCHIVELOG to ARCHIVELOG migration
- From: "Andrey Kriushin" <Andrey.Kriushin@xxxxxxxx>
- To: "LS Cheng" <exriscer@xxxxxxxxx>
- Date: Thu, 27 Apr 2006 00:36:38 +0400 (MSD)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
