/dev/oracleasm/disks/DISK03 仲裁磁盘(QUORUM disk)
prod01磁盘(/dev/oracleasm/disks/VOTEDB01,/dev/oracleasm/disks/NODE01DATA01)
prod02磁盘(/dev/oracleasm/disks/VOT02,/dev/oracleasm/disks/NODE02DATA01)
注意设置磁盘组属性:11.2.0.0.0(COMPATIBILITY,DATABASE_COMPATIBILITY)
_asm_storagemaysplit 建议设置为TRUE
OCR ,VOTEDISK 分2个磁盘组存放
补丁信息:18317531
ocr 配置
[grid@prod01 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3052
Available space (kbytes) : 259068
ID : 204222775
Device/File Name : +ocr
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check bypassed due to non-privileged user
votedisk 信息
[grid@prod01 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 88080bfc44de4f54bfccdd8b0151aef6 (/dev/oracleasm/disks/DISK03) [CRS]
2. ONLINE a7e97bcb21484f29bf65b043e90f5db2 (/dev/oracleasm/disks/VOT02) [CRS]
3. ONLINE 91d97d42bcfa4fd0bf1788a668986541 (/dev/oracleasm/disks/VOTEDB01) [CRS]
Located 3 voting disk(s).
asm 磁盘信息:
SQL> col name for a39
SQL> select a.ksppinm name, b.ksppstvl value, a.ksppdesc describe
2 from x$ksppi a, x$ksppcv b
where a.inst_id = userenv('Instance')
and b.inst_id = userenv('Instance')
and a.indx = b.indx
and a.ksppinm like '\_asm_storagemaysplit%' escape '\'
order by name; 3 4 5 6 7
NAME VALUE DESCRIBE
--------------------------------------- -------- ----------------------------------------------------------------------
_asm_storagemaysplit TRUE PST Split Possible
SQL> @c
DG_NAME DG_STATE TYPE DSK_NO DSK_NAME PATH MOUNT_S FAILGROUP STATE
--------------- ---------- ------ ---------- ---------- -------------------------------------------------- ------- -------------------- --------
CRS MOUNTED NORMAL 2 CRS_0002 /dev/oracleasm/disks/DISK03 CACHED ZCDISK NORMAL
CRS MOUNTED NORMAL 5 CRS_0005 /dev/oracleasm/disks/VOTEDB02 CACHED CRS_0001 NORMAL
CRS MOUNTED NORMAL 9 CRS_0009 /dev/oracleasm/disks/VOTEDB01 CACHED CRS_0000 NORMAL
OCR MOUNTED NORMAL 0 OCR_0000 /dev/oracleasm/disks/NODE01DATA01 CACHED OCR_0000 NORMAL
OCR MOUNTED NORMAL 1 OCR_0001 /dev/oracleasm/disks/NODE02DATA01 CACHED OCR_0001 NORMAL
DISK_NUMBER NAME PATH HEADER_STATUS OS_MB TOTAL_MB FREE_MB REPAIR_TIMER V FAILGRO
----------- ---------- -------------------------------------------------- -------------------- ---------- ---------- ---------- ------------ - -------
0 OCR_0000 /dev/oracleasm/disks/NODE01DATA01 MEMBER 5120 5120 3185 0 N REGULAR
1 OCR_0001 /dev/oracleasm/disks/NODE02DATA01 MEMBER 5120 5120 3185 0 N REGULAR
9 CRS_0009 /dev/oracleasm/disks/VOTEDB01 MEMBER 2048 2048 1584 0 Y REGULAR
5 CRS_0005 /dev/oracleasm/disks/VOTEDB02 MEMBER 2048 2048 1648 0 Y REGULAR
2 CRS_0002 /dev/oracleasm/disks/DISK03 MEMBER 5115 5115 5081 0 Y QUORUM
GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILITY V
------------ ---------- ------------------------------------------------------------ ------------------------------------------------------------ -
1 OCR 11.2.0.0.0 11.2.0.0.0 N
2 CRS 11.2.0.0.0 11.2.0.0.0 Y
SQL>