Why does Voting File is different in different nodes [message #615266] |
Sun, 01 June 2014 09:55  |
 |
juniordbanewbie
Messages: 250 Registered: April 2014
|
Senior Member |
|
|
Initially I have a one node RAC, later, in $GRID_HOME, the initohasd files is missing, so I've to deconfigure the clusterware and reinstall $GRID_BINARIES, in the process I also drop the diskgroup that contains both Voting disk and OCR. What happens is that I empty the disk before marking them with oracleasm libraries, i.e. /etc/init.d/oracleasm create disk OCR_VOTE 1 /dev/asm-ocr-vote1_part1.
Before I deconfigure the clusteware, I've used udev to mark the disk.
So after resintalling the grid binaries, I found some unexplained observations.
On my first node
grid@ORCL01:~> crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 3cf0990ca73f4f58bf18bcb9874524be (ORCL:OCR_VOTE1) [OCR_VOTE]
Located 1 voting disk(s).
on my second node
grid@ORCL02:~> crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 3cf0990ca73f4f58bf18bcb9874524be (/dev/asm-ocr-vote1_part1) [OCR_VOTE]
Located 1 voting disk(s).
grid@ORCL02:~>
Why is it in the second node it is reflecting the old udev path and not the oracleasm lib path (ORCL:OCR_VOTE1)
many thanks in advance!
|
|
|
|
Re: Why does Voting File is different in different nodes [message #617504 is a reply to message #615423] |
Mon, 30 June 2014 20:31   |
 |
juniordbanewbie
Messages: 250 Registered: April 2014
|
Senior Member |
|
|
over at ASM2
col mount_status format a6
col header_status format a6
col mode_status format a6
col state format a6
col name format a9
col path format a24
SELECT disk.mount_status, disk.header_status, disk.mode_status, disk.state, disk.name, disk.path FROM v$asm_disk disk JOIN v$asm_diskgroup dg ON
disk.group_number = dg.group_number
WHERE dg.name='OCR_VOTE' ORDER BY disk.name;
MOUNT_ HEADER MODE_S STATE NAME PATH
------ ------ ------ ------ --------- ------------------------
CACHED MEMBER ONLINE NORMAL OCR_VOTE1 /dev/asm-ocr-vote1_part1
CACHED MEMBER ONLINE NORMAL OCR_VOTE2 /dev/asm-ocr-vote2_part1
CACHED MEMBER ONLINE NORMAL OCR_VOTE3 /dev/asm-ocr-vote3_part1
querydisk at ORCL02
ORCL02:~ # oracleasm querydisk -d OCR_VOTE1
Disk "OCR_VOTE1" is a valid ASM disk on device [8,97]
over at ASM1
SYS@ASM1>ed
Wrote file afiedt.buf
1 SELECT disk.mount_status, disk.header_status, disk.mode_status, disk.state,
disk.name, disk.path FROM v$asm_disk disk JOIN v$asm_diskgroup dg ON
2 disk.group_number = dg.group_number
3* WHERE dg.name='OCR_VOTE' ORDER BY disk.name
SYS@ASM1>/
MOUNT_ HEADER MODE_S STATE NAME PATH
------ ------ ------ ------ --------- ---------------
CACHED MEMBER ONLINE NORMAL OCR_VOTE1 ORCL:OCR_VOTE1
CACHED MEMBER ONLINE NORMAL OCR_VOTE2 ORCL:OCR_VOTE2
CACHED MEMBER ONLINE NORMAL OCR_VOTE3 ORCL:OCR_VOTE3
SYS@ASM1>
querydisk at ORCL01
ORCL01:~ # oracleasm querydisk -d OCR_VOTE1
Disk "OCR_VOTE1" is a valid ASM disk on device [253,43]
|
|
|
|