Add Remove Migrate the Voting file in Oracle 12c RAC Environment
Oracle ASM used in Oracle 12c to manage the voting files. ASM manages the voting file differently from other files stored in ASM.
Number of Voting files stored depend upto redundancy of ASM diskgroup.
A quorum failure group is a special type of failure group that is used to store the Oracle Clusterware voting files. Quorum failure group not stored user data.
Note: dd command is not supported in Oracle 12c clusterware.
For Oracle Clusterware files
Normal redundancy disk group
requires a minimum of three disk devices.
Two of the three disks are used by failure groups and all three disks are used by the quorum failure group.
Configured three voting files and one OCR and mirror of the OCR.
The cluster can survive the loss of one failure group.
High Redundancy disk group
requires a minimum of five disk devices.
Three of the five disks are used by failure groups and all five disks are used by the quorum failure group.
Configured five voting files and one OCR and two mirrors of the OCR.
the cluster can survive the loss of two failure groups.
Restore the voting files
If all voting files are corrupted. you can restored as:
1. Start the clustware in exclusive mode.
crsctl start crs -excl
2. Get the present detail of voting files.
crsctl query css votedisk
-- ----- ----------------- --------- --------- ## STATE File Universal Id File Name Disk group 1. ONLINE 6f57843d89464c46ea747e8a3fa43 (/dev/sdb1) [DATA] 2. ONLINE 7c54856e98474f61bf349e7c9fb95 (/dev/sdc1) [DATA] 3. ONLINE 9c46232b76234f61fc934d5c8ec59 (/dev/sdd1) [DATA]
3. Restore the voting file
-- If voting files are stored in ASM disk then
crsctl replace votedisk +asm_disk_group
-- If voting files are not stored in ASM then
crsctl delete css votedisk FUID
crsctl add css votedisk path_to_voting_disk
--FUID value in 2 step file universal id
4. Stop the clusterware with root user:
crsctl stop crs
--force fully
crsctl stop crs -f
5. Start the clustware with root user:
crsctl start crs
Modifying Voting Files that are Stored in Oracle ASM
Display the voting file information
crsctl query css votedisk
-- ----- ----------------- --------- --------- ## STATE File Universal Id File Name Disk group 1. ONLINE 6f57843d89464c46ea747362e8a3fa43 (/dev/sdb1) [DATA] 2. ONLINE 7c54856e98474f61bf349401e7c9fb95 (/dev/sdc1) [DATA] 3. ONLINE 9c46232b76234f61fc934673d5c8ec59 (/dev/sdd1) [DATA]
Migrate voting files from Oracle ASM to an storage device already stored in Oracle ASM
crsctl replace votedisk path_to_voting_disk
Migrating Voting Files to Oracle ASM
crsctl replace votedisk +asm_disk_group
ADD more file not stored in Oracle ASM
Replacing path value in following command to add more voting disk in filesystem
-- For Add more voting disk in filesystem
crsctl add css votedisk path_to_voting_disk
--Replacing the existing voting file with purge clause
crsctl add css votedisk path_to_voting_diskB -purge
Remove the voting file not in Oracle ASM
crsctl delete css votedisk {FUID | path_to_voting_disk[...]}