|
小弟理解這些還真有些難度,經過nokilled提點繼續實驗,得出個小小結論,還請大家指教;
在normal redundancy情況下:
含用Quorum Failure Group的DG,將votedisk存儲在這個DG中時,將自動在Quorum Failure Group和常規Failure Group各存一份,
OCR及用戶數據僅存放在常規Failure Group;這些文件的存放位置由DB自動完成
很多地方說OCR和votedisk都會存儲在Quorum,經過下面的實驗說明是錯誤的,只有votedisk存儲在Quorum。
所以,我感覺單獨搞個Quorum Failure Group是件多余事情,它僅保證將votedisk存放一份在獨立的asmdisk中
(OCR有自動備份的機制,10G中votedisk可以通過dd等命令備份,而11G ASM裡面還沒有針對votedisk單獨的備份機制,可能這是個原因)
我可以把votedisk多放在幾個DG中也可以保障它的安全
另外,OCR是以asmfile的形式存儲在DG中的,votedisk在DG中找不到實質的文件,由此也可以猜想一下acfs,asm的啟動機制 啦啦......
[root@rac1 bin]# ./crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 64a6332cd1ad4fd3bfce95ca38bf18f8 (ORCL:ASMDISK1) [DATA]
實驗過程:
SQL> CREATE DISKGROUP QUO_GRP NORMAL REDUNDANCY
2 FAILGROUP fg1 DISK 'ORCL:ASMDISK3'
3 FAILGROUP fg2 DISK 'ORCL:ASMDISK4'
4 QUORUM FAILGROUP fg3 DISK 'ORCL:ASMDISK5'
5 ATTRIBUTE 'compatible.asm' = '11.2.0.0.0';
--我是通過圖形介面創建的,這裡把命令還原出來。
SQL> select a.GROUP_NUMBER,b.name group_name,a.DISK_NUMBER,a.PATH,a.TOTAL_MB, a.FREE_MB,a.failgroup_type
2 from v$asm_disk a,v$asm_diskgroup b where a.group_number=b.group_number and a.group_number=1;
GROUP_NUMBER GROUP_NAME DISK_NUMBER PATH TOTAL_MB FREE_MB FAILGROUP_TYPE
------------ --------------- ----------- -------------------- ---------- ---------- --------------
1 DATA2 0 ORCL:ASMDISK3 2047 1952 REGULAR
1 DATA2 1 ORCL:ASMDISK4 2047 1952 REGULAR
1 DATA2 2 ORCL:ASMDISK5 2047 2045 QUORUM
[root@rac1 bin]# ./crsctl replace votedisk +DATA2
Successful addition of voting disk 64a6332cd1ad4fd3bfce95ca38bf18f8.
Successful addition of voting disk 3d3a807e0fa14ff2bf6b6609788e1d1a.
Successful addition of voting disk b030035ea4894fc0bfba8f6b76ae5513.
Successful deletion of voting disk 1e137cab54294f6bbfe173e129f744b2.
Successfully replaced voting disk group with +DATA2.
CRS-4266: Voting file(s) successfully replaced
[root@rac1 bin]# ./crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 64a6332cd1ad4fd3bfce95ca38bf18f8 (ORCL:ASMDISK5) [DATA2]
2. ONLINE 3d3a807e0fa14ff2bf6b6609788e1d1a (ORCL:ASMDISK3) [DATA2]
3. ONLINE b030035ea4894fc0bfba8f6b76ae5513 (ORCL:ASMDISK4) [DATA2]
Located 3 voting disk(s).
SQL> select a.GROUP_NUMBER,b.name group_name,a.DISK_NUMBER,a.PATH,a.TOTAL_MB, a.FREE_MB,a.failgroup_type
2 from v$asm_disk a,v$asm_diskgroup b where a.group_number=b.group_number and a.group_number=1;
GROUP_NUMBER GROUP_NAME DISK_NUMBER PATH TOTAL_MB FREE_MB FAILGROUP_TYPE
------------ --------------- ----------- -------------------- ---------- ---------- --------------
1 DATA2 0 ORCL:ASMDISK3 2047 1920 REGULAR
1 DATA2 1 ORCL:ASMDISK4 2047 1920 REGULAR
1 DATA2 2 ORCL:ASMDISK5 2047 2013 QUORUM
可見DATA2中的三塊磁盤容量都減少了;
[root@rac1 bin]# ./ocrconfig -add +DATA2
SQL> select a.GROUP_NUMBER,b.name group_name,a.DISK_NUMBER,a.PATH,a.TOTAL_MB, a.FREE_MB,a.failgroup_type
2 from v$asm_disk a,v$asm_diskgroup b where a.group_number=b.group_number and a.group_number=1;
GROUP_NUMBER GROUP_NAME DISK_NUMBER PATH TOTAL_MB FREE_MB FAILGROUP_TYPE
------------ --------------- ----------- -------------------- ---------- ---------- --------------
1 DATA2 0 ORCL:ASMDISK3 2047 1652 REGULAR
1 DATA2 1 ORCL:ASMDISK4 2047 1652 REGULAR
1 DATA2 2 ORCL:ASMDISK5 2047 2013 QUORUM
可見DATA2中只有failure group中有兩塊磁盤容量減少了,QUORUM並沒有減速少,說明OCR只會存在常規failure group中;
[ 本帖最后由 jdw618 于 2011-6-3 13:28 编辑 ] |
|