RAC in Active/Passive mode (or disabled)

We are running a 4 nodes RAC on Sun Solaris 10, each node with 16 quadcore CPU and 512GB memory. There are 12 database in this Cluster.

We have observed that some instances are running with low activity and some needs more horsepower when batch processes kick in. Basically in some nodes we are wasting resources which can be used for other instances.

The way we have configured the databases are setting same SGA in all nodes so in those idle instances memory is wasted.

We are considering reorganize the memory distributions and databases/instances distribution. For example for database APP1 just configure two active instances and two passive, for the heavy OLTP system all 4 nodes etc.

I have been considering disabling the instance startup for the passive nodes. What is the the better method, reconfigure the database in two nodes only by using dbca or disabling the instance startup? (srvctl disable instance)

TIA
--

LSC
--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 07 2009 - 06:04:38 CDT