Re: How about just open one node of RAC in read write mode, others in read only mode?
- From: Lou Fangxin <anysql@xxxxxxxxx>
- To: fairlie rego <fairlie_r@xxxxxxxxx>, Oracle Mailing List <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 7 Dec 2005 09:08:22 +0800
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@xxxxxxxxx> 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: 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@xxxxxxxxx>* 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/
Other related posts:
