Maybe oracle should enable this, this can be act as a specify RAC model. It should be simple than current RAC mode, and more robust.
On 12/7/05, fairlie rego <fairlie_r@(protected)> wrote: > > Hi, > > This is not possible > > If you open the database on one node as read write you cannot open it read > only mode. > > SQL> alter database open read only; > alter database open read only > * > ERROR at line 1: > ORA-16002 (See ORA-16002.ora-code.com): database already open for read-write access by another instance > > From the top of my head I do not remember whether the controlfile or > datafile header is updated with this info. > > Regards, > -Fairlie > > *Lou Fangxin <anysql@(protected)>* wrote: > > 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/ > > > > > > *Fairlie Rego > *Senior Oracle Consultant > Optus Telecommunications > www.optus.com.au > Mobile: +61 4 02 792 405 > Home: +61 2 8920 0273 > > > When I read about the evils of drinking, I gave up reading. > > -- ---- ---- ---- ---- ---- -- > *Yahoo! Personals* > Skip the bars and set-ups and start using Yahoo! Personals for free<http://us .rd.yahoo.com/evt=36107/*http://personals.yahoo.com/us/reg/free7days+%0A> > >
-- Welcome! Home: http://www.anysql.net/en/
Maybe oracle should enable this, this can be act as a specify RAC model. It should be simple than current RAC mode, and more robust.<br><br> <div><span class="gmail_quote">On 12/7/05, <b class="gmail_sendername">fairlie rego</b> <<a href="mailto:fairlie_r@(protected)">fairlie_r@(protected)</a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid"> <div>Hi,</div> <div> </div> <div>This is not possible</div> <div> </div> <div>If you open the database on one node as read write you cannot open it read only mode.</div> <div> </div> <div>SQL> alter database open read only;<br>alter database open read only<br >*<br>ERROR at line 1:<br>ORA-16002 (See ORA-16002.ora-code.com): database already open for read-write access by another instance<br> </div> <div>From the top of my head I do not remember whether the controlfile or datafile header is updated with this info.</div> <div> </div> <div>Regards,</div> <div>-Fairlie <div><span class="e" id="q_10802a75a6302efb_1"><br><br><b><i>Lou Fangxin <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:anysql @(protected)" target="_blank">anysql@(protected)</a>></i></b> wrote: </span></div></div> <div><span class="e" id="q_10802a75a6302efb_3"> <blockquote style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"> <div>Hi all:</div> <div> </div> <div> 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.<br clear="all"> <br>-- <br>Welcome!<br>Home: <a onclick="return top.js.OpenExtLink(window,event ,this)" href="http://www.anysql.net/en/" target="_blank">http://www.anysql.net /en/</a> </div></blockquote> <div><br> </div><br><br></span></div> <div> <div> <div> <div> <div> <div><strong>Fairlie Rego<br></strong>Senior Oracle Consultant</div> <div>Optus Telecommunications</div> <div><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www .optus.com.au/" target="_blank">www.optus.com.au</a></div> <div>Mobile: +61 4 02 792 405</div> <div>Home: +61 2 8920 0273</div> <div><br> </div> <div><font face="comic sans ms">When I read about the evils of drinking, I gave up reading</font>.</div></div></div></div></div></div><span class="ad"> <p> <hr size="1"> <b>Yahoo! Personals</b><br>Skip the bars and set-ups and <a onclick="return top .js.OpenExtLink(window,event,this)" href="http://us.rd.yahoo.com/evt=36107/*http ://personals.yahoo.com/us/reg/free7days+%0A" target="_blank"> start using Yahoo! Personals for free</a> <p></p></p></span></blockquote></div><br><br clear="all"><br>-- <br>Welcome!<br >Home: <a href="http://www.anysql.net/en/">http://www.anysql.net/en/</a>
