Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g RAC Question

Re: Oracle 10g RAC Question

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 6 Oct 2004 02:08:37 -0700
Message-ID: <1e8276d6.0410060108.5f81d92d@posting.google.com>


"Howard J. Rogers" <howardjr_at_dizwell.com> wrote in message news:<4163091b$0$23894$afc38c87_at_news.optusnet.com.au>...
> > More or less RAC is the beast formerly know as a parallel server. You
> > are assuming right about disk devices. However, all nodes must see the
> > same datafiles, so node 1 & node 2 & node 3 must see at least X. The
> > storage config is the same for all nodes on RAC.
> > Instead of raw devices you can also use a certified clustered
> > filesystem.
> >
> Where your sentence reads 'node 1, node 2 and node 3 must see at least disk
> group X', that is therefore not generically true. It is only true if, on
> those nodes, there are instances which seek to manage the same database
> which happens to be stored on disk group X.
>
> I also don't understand what "the storage config is the same for all nodes
> on RAC", either. I think it falls into the same category of wobbly
> distinction between RACing and Clustering.

It is true that my post was not very clear on this. The meaning of this was that he must see from all RAC nodes at least one storage where he could put his datafiles. All others could be assigned as needed for other purposes, but mount points for his clustered database must be accessible from all nodes. In his post he asked about three node RAC setup, so for me these nodes are the ones dedicated for RAC. We were not talking about general clustering, but about his planned RAC.
The sentence about the same storage config should be taken from a database point of view. In his post, you can see the question if each node can have different tablespaces assigned (for several application), that is not possible and the *ORACLE* storage configuration (datafiles, tablespaces) must be the same for all nodes, which is obvious because RAC is only single database served by several instances.
In this thread, we are not talking about general clustering. For mount points not used for RAC database there could be any M-N assigment to nodes as needed.

--
Dusan Bolek
http://www.db-support.com

Email: spambin_at_seznam.cz
Pls add "Not Guilty" to the subject, otherwise your email will face an
unpleasant end as SPAM.
Received on Wed Oct 06 2004 - 04:08:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US