IDENTIFY MASTER NODE IN RAC

Get master node details from

1)ohasd logfile

[oracle@exdbadm01 ohasd]$ grep 'MASTER' ohasd.log|tail
2021-04-07 16:23:05.580: [   CRSPE][2999859520]{0:0:2} PE Role|State Update: old role [MASTER] new [MASTER]; old state [Configuring] new [Starting]
2021-04-07 16:23:05.582: [   CRSPE][2999859520]{0:0:2} PE Role|State Update: old role [MASTER] new [MASTER]; old state [Starting] new [Running]
2021-04-08 13:39:13.858: [   CRSPE][839031104]{0:0:2} PE Role|State Update: old role [INVALID] new [MASTER]; old state [Enabling: waiting for role] new [Configuring]
2021-04-08 13:39:13.858: [   CRSPE][839031104]{0:0:2} PE MASTER NAME: exdbadm01
2021-04-08 13:39:14.569: [   CRSPE][839031104]{0:0:2} PE Role|State Update: old role [MASTER] new [MASTER]; old state [Configuring] new [Starting]
2021-04-08 13:39:14.571: [   CRSPE][839031104]{0:0:2} PE Role|State Update: old role [MASTER] new [MASTER]; old state [Starting] new [Running]
2021-04-09 13:21:01.639: [   CRSPE][2623547712]{0:0:2} PE Role|State Update: old role [INVALID] new [MASTER]; old state [Enabling: waiting for role] new [Configuring]
2021-04-09 13:21:01.639: [   CRSPE][2623547712]{0:0:2} PE MASTER NAME: exdbadm01
2021-04-09 13:21:02.548: [   CRSPE][2623547712]{0:0:2} PE Role|State Update: old role [MASTER] new [MASTER]; old state [Configuring] new [Starting]
2021-04-09 13:21:02.551: [   CRSPE][2623547712]{0:0:2} PE Role|State Update: old role [MASTER] new [MASTER]; old state [Starting] new [Running]

2)v$ges_resource dynamic parameter

kish@exdbx<>select RESP,RESOURCE_NAME,MASTER_NODE,NEXT_CVT_LEVEL from v$ges_resource where rownum < 11;

RESP             RESOURCE_NAME                                               MASTER_NODE NEXT_CVT_
---------------- ------------------------------ ---------------------------------------- ---------
00000000C64D7128 [0x43c0f61e][0xb9c6fb9e],[QQ][                                        0 KJUSERNL
00000000D1977698 [0xd9ac5aaf][0x38a98ebb],[QQ][                                        0 KJUSERNL
00000000D1913028 [0x682062be][0x33658b50],[QQ][                                        0 KJUSERNL
00000000D19011D8 [0x4c4f434b][0x39],[IV][ext 0x                                        0 KJUSERNL
00000000D187C048 [0x33708fee][0x6bf1a91f],[QQ][                                        1 KJUSERNL
00000000D18F53E0 [0x36818230][0x751c0852],[QI][                                        0 KJUSERNL
00000000C665CF90 [0x801502][0x1],[QC][ext 0x0,0                                        1 KJUSERNL
00000000C680AC78 [0xf1b15c0b][0x50a5d6ae],[QQ][                                        1 KJUSERNL
00000000D1890688 [0xe7532ae4][0x24fdb5df],[QQ][                                        1 KJUSERNL
00000000D18CE9C8 [0xf9a5536][0x6254bff1],[QQ][e                                        1 KJUSERNL

3)ocssd logfile

[oracle@exdbadm01 ~]$ grep 'MASTER' /u01/app/11.2.0/log/exdbadm01/cssd/ocssd.log|tail

2021-04-09 14:06:25.972: [    CSSD][1021745472]clssgmTestSetLastGrockUpdate: grock(CLSN.RLB.exdbx.MASTER), updateseq(5) msgseq(6), lastupdt<0x20992b0>, ignoreseq(0)
2021-04-09 14:06:25.972: [    CSSD][1021745472]clssgmGrockOpTagProcess: Request to commission member(1) using key(1) for grock(CLSN.RLB.exdbx.MASTER)
2021-04-09 14:06:25.972: [    CSSD][1021745472]clssgmUpdateGrpData: grock(CLSN.RLB.exdbx.MASTER), commissioner(1/1)
2021-04-09 14:06:25.973: [    CSSD][1021745472]clssgmQueueGrockEvent: groupName(CLSN.RLB.exdbx.MASTER) count(2) master(2) event(18), incarn 1, mbrc 1, to member 1, events 0xa0, state 0x0
2021-04-09 14:06:25.973: [    CSSD][1021745472]clssgmHandleGrockRcfgUpdate: grock(CLSN.RLB.exdbx.MASTER), updateseq(6), status(0), sendresp(1)
2021-04-09 14:06:26.554: [    CSSD][1021745472]clssgmTestSetLastGrockUpdate: grock(CLSN.RLB.exdbx.MASTER), updateseq(6) msgseq(7), lastupdt<0x2098dd0>, ignoreseq(0)
2021-04-09 14:06:26.554: [    CSSD][1021745472]clssgmGrockOpTagProcess: Request to commission member(-1) using key(1) for grock(CLSN.RLB.exdbx.MASTER)
2021-04-09 14:06:26.554: [    CSSD][1021745472]clssgmUpdateGrpData: grock(CLSN.RLB.exdbx.MASTER), commissioner(-1/0)
2021-04-09 14:06:26.554: [    CSSD][1021745472]clssgmQueueGrockEvent: groupName(CLSN.RLB.exdbx.MASTER) count(2) master(2) event(18), incarn 0, mbrc 1, to member 1, events 0xa0, state 0x0
2021-04-09 14:06:26.554: [    CSSD][1021745472]clssgmHandleGrockRcfgUpdate: grock(CLSN.RLB.exdbx.MASTER), updateseq(7), status(0), sendresp(1)

4)crsd logfile

[oracle@exdbadm01 ~]$ grep 'MASTER' /u01/app/11.2.0/log/exdbadm01/crsd/crsd.log|tail


2021-04-07 16:37:55.261: [  OCRMAS][1307658560]th_master: NEW OCR MASTER IS 2
2021-04-07 16:37:57.188: [   CRSPE][1370696000]{1:39863:2} PE MASTER NAME: exdbadm02
2021-04-08 14:38:20.591: [  OCRMAS][1711864128]th_master:12: I AM THE NEW OCR MASTER at incar 1. Node Number 1
2021-04-08 14:38:23.231: [   CRSPE][1849760064]{1:43178:2} PE Role|State Update: old role [INVALID] new [MASTER]; old state [Enabling: waiting for role] new [Configuring]
2021-04-08 14:38:23.231: [   CRSPE][1849760064]{1:43178:2} PE MASTER NAME: exdbadm01
2021-04-08 14:38:24.739: [   CRSPE][1849760064]{1:43178:2} PE Role|State Update: old role [MASTER] new [MASTER]; old state [Configuring] new [Starting]
2021-04-08 14:38:24.745: [   CRSPE][1849760064]{1:43178:2} PE Role|State Update: old role [MASTER] new [MASTER]; old state [Starting] new [Running]
2021-04-09 14:02:49.296: [  OCRMAS][2666457408]proath_master: SUCCESSFULLY CONNECTED TO THE MASTER
2021-04-09 14:02:49.296: [  OCRMAS][2666457408]th_master: NEW OCR MASTER IS 2
2021-04-09 14:02:52.784: [   CRSPE][2729494848]{1:57928:2} PE MASTER NAME: exdbadm02

5)Recent OCR backup taken by any node is MASTER B)

[oracle@exdbadm01 ~]$ ocrconfig -showbackup

exdbadm02     2021/04/09 22:18:00     /u01/app/11.2.0/cdata/exdbadm-scan/backup00.ocr <==== I am Master 

exdbadm02     2021/04/09 18:17:58     /u01/app/11.2.0/cdata/exdbadm-scan/backup01.ocr

exdbadm01     2021/04/08 22:53:32     /u01/app/11.2.0/cdata/exdbadm-scan/backup02.ocr

exdbadm01     2021/04/08 18:53:31     /u01/app/11.2.0/cdata/exdbadm-scan/day.ocr

exdbadm01     2021/04/03 17:27:41     /u01/app/11.2.0/cdata/exdbadm-scan/week.ocr

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s