Re: RAC in Active/Passive mode (or disabled)
Date: Mon, 07 Sep 2009 11:02:17 -0500
Personally I'd just use srvctl - probably makes it much easier to "relocate" instances.
In fact 11gR2 will do this for you automatically. For those who haven't had a chance to look closely yet, RAC has some major new features. One of them (policy-based cluster mgmt) will automatically re-allocate a node between two cluster DBs by shutting down and starting up instances - driven by response times - and of course within limits that you set. Look for "server pools" in the docs. Pretty interesting-looking new feature; I think it's one of the most significant of the release. :)
LS Cheng wrote:
> Hi all
> 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)
-- Jeremy Schneider Chicago, IL http://www.ardentperf.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 07 2009 - 11:02:17 CDT