Home » Server Options » RAC & Failsafe » Why does Voting File is different in different nodes (Oracle 11.2.0.1 SuSe LInux 11 SP3)
|
|
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]
|
|
|
|
Goto Forum:
Current Time: Sun May 04 15:48:06 CDT 2025
|