Manage the Voting file in Oracle 12c RAC Environment

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[...]}

Advertisements