Make Oracle ASM voting file online
December 9, 2021 Leave a comment
Problem:
After changing the quorum node instance type, my cluster’s one of the voting file became offline:
[root@rac1 ~]# crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 49400dd2b39a4f12bf3c5fa677c056fe (/dev/flashgrid/rac2.xvdba) [GRID] 2. ONLINE 4a6d94d206104fe6bfbe5435ac7f4586 (/dev/flashgrid/rac1.xvdba) [GRID] 3. OFFLINE faf99f5fd78f4f35bfe833bdd1d22b9a (/dev/flashgrid/racq.xvdba) [GRID] Located 3 voting disk(s).
Solution:
Find out the ASM disk name which contains mentioned voting file, offline and online it:
SQL> select NAME from v$ASM_DISK where PATH='/dev/flashgrid/racq.xvdba'; NAME ------------------------------ RACQ$XVDBA
Offline the disk:
SQL> alter diskgroup GRID offline quorum disk "RACQ$XVDBA"; Diskgroup altered.
Online again:
SQL> alter diskgroup GRID online quorum disk "RACQ$XVDBA"; Diskgroup altered.
Check the status again:
SQL> !crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 49400dd2b39a4f12bf3c5fa677c056fe (/dev/flashgrid/rac2.xvdba) [GRID] 2. ONLINE 4a6d94d206104fe6bfbe5435ac7f4586 (/dev/flashgrid/rac1.xvdba) [GRID] 3. ONLINE 784f924d23c94f3fbf4287c5c6ef572c (/dev/flashgrid/racq.xvdba) [GRID]