QCR, Voting Disk & Quorum failure group in ASM

QCR, Voting Disk & Quorum failure group in ASM

Voting Disk and Oracle Cluster Registry (OCR) can store inside of an Automatic Storage Management(ASM) Disk Group in Oracle 11gR2.

Oracle Cluster Registry (OCR)
OCR is striped and mirrored similar as ordinary Database Files.
So we can now have option the mirroring capabilities of ASM to mirror the OCR also, without having to use multiple RAW devices for that purpose only.
The Oracle RAC configuration information repository that manages information about the cluster node list and instance-to-node mapping information.
Oracle Clusterware rely on ASM to access the OCR and SPFILE. The OCR and SPFILE are stored similar to how Oracle Database files are stored.

Voting Disk
Voting disk is not striped but put as a whole on ASM Disks
if we use a redundancy of normal on the Diskgroup, 3 Voting Files are placed, each on one ASM Disk into a different failgroup.
Therefore, you need to have at least 3 failgroups for that diskgroup, like on this picture:

Quorum failure group
A quorum failure group is a special type of failure group that does not contain user data. Quorum failure groups are used for storing Oracle ASM metadata.
A quorum failure group may also contain voting files if those files are stored in a disk group that contains a quorum failure group.

Note: COMPATIBLE.ASM disk group compatibility attribute must be set to 11.2 or greater to store OCR or voting disk data in a disk group.

Check the disk having voting disk

Select name,voting_file from $asm_disk where VOTING_FILE = 'Y';

Check fail-group type

Select FAILGROUP_TYPE from V$ASM_DISK ;
select FAILGROUP_TYPE from V$ASM_DISK_STAT;

if our ASM Diskgroups consist of only 2 ASM Disks respectively only 2 failgroups like with Extended RAC! Therefore, the new quorum failgroup clause was introduced:

Create Quoram failgroup in diskgroup

create diskgroup data normal redundancy
failgroup fg1 disk 'ORCL:ASMDISK1'
failgroup fg2 disk 'ORCL:ASMDISK2'
quorum failgroup fg3 disk 'ORCL:ASMDISK3'
attribute 'compatible.asm' = '11.2.0.0.0';

FAILGROUP fg3 above needs only one small Disk (300 MB should be on the safe side here, since the Voting File is only about 280 MB in size) to keep one Mirror of the Voting File.
fg1 and fg2 will contain each one Voting File and all the other stripes of the Database Area as well, but fg3 will only get that one Voting File.

Check the quorum disk

select b.name group_name, a.PATH, a.TOTAL_MB, a.failgroup_type
from v$asm_disk a, v$asm_diskgroup b where a.group_number = b.group_number and a.group_number = 1;

GROUP_NAME  PATH          TOTAL_MB  FAILGROUP_TYPE
----------  ------------- --------  --------------
DATA1       ORCL:ASMDISK3 2047      REGULAR
DATA1       ORCL:ASMDISK4 2047      REGULAR
DATA1       ORCL:ASMDISK5 2047      QUORUM

Note: In 11gR2 Voting file backup is done with QCR backup. It’s not supported manually dd backup.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.