Saturday, June 8, 2013

How to identify Master Node in RAC?

Master Node in RAC is at
1) Cluster Level
2) Object level

ocrconfig -showbackup  --> Gives the node from where the backup of OCR is taken. This is the Master Node at OCR

Also, from search for Master in crsd.log files

from ocssd.log or ocssd.l01

grep -i "master node" ocssd.l01 | tail -1
2013-06-07 18:30:06.056: [    CSSD][1285093696]clssgmCMReconfig: reconfiguration successful, incarnation 256448479 with 2 nodes, local node number 1, master node number 2


At object level:

Use GV$GES_RESOURCE for Master_node column.

You can manually remaster an object with oradebug command:
SQL> oradebug lkdebug -m pkey "object_id"

No comments: