Re: How to determine which is the master node in RAC cluster?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 29 Aug 2006 14:21:49 -0700
Message-ID: <1156886509.222848.302700@m73g2000cwd.googlegroups.com>

wagen123_at_yahoo.com wrote:
> Oracle10g 10.2.0.2 (64 bit)
> RHEL 4.3 (64 bit)
>
> How to determine which is the master node in RAC cluster? Ex. in a 4
> node RAC cluster.
>
> Thanks
> wagen

One node is always going to be the first to open the database files ...
***
ALTER DATABASE OPEN
This instance was first to open
Picked Lamport scheme to generate SCNs
***

You can see that from the alert logs ...

Normally you control which thread # an instance operates with ( each has their own separate set of redo logs ).

But aside from those types of considerations there is no "master" node.

Resources within the database schema's ( tables/blocks/rows etc ) may and will change while the database operates in terms of what node has the most current copy. Received on Tue Aug 29 2006 - 16:21:49 CDT