/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>

友情链接
ioDraw流程图
API参考文档
OK工具箱
云服务器优惠
阿里云优惠券
腾讯云优惠券
华为云优惠券
站点信息
问题反馈
邮箱:ixiaoyang8@qq.com
QQ群:637538335
关注微信