RE: How about just open one node of RAC in read write mode, others in read only mode?

I don't know whether that is possible, but it would be far easier to simply route only read only jobs to the non-writer instances. Without either agreeing or disagreeing with your premise, I think this would allow you to achieve what you are trying to achieve so you can assess whether your throughput increases in that model. You'll have to do the routing work anyway, lest write jobs land on a read only instance and go splat with an error. This model would be more forgiving, and you could monitor redo generation on the "intended read only" instances to check for unintended update jobs that land there.

Sounds like an interesting experiment, especially if you have captured your current throughput in a way useful to compare against the new way.

Regards,

mwf
  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Lou Fangxin   Sent: Tuesday, December 06, 2005 7:23 AM   To: Oracle Mailing List
  Subject: How about just open one node of RAC in read write mode, others in read only mode?

  Hi all:

     RAC is still not good under multi-node write mode, so can I just open one node in read write node and other nodes in read only mode, is it possible? I just want to force a one-write-multi-read model.

  --
  Welcome!
  Home: http://www.anysql.net/en/

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