oracle asm指定故障组添加磁盘
【摘要】 原来磁盘信息：col name format a15;col path format a30;col failgroup format a20;select dg.name, d.path, d.failgroup, d.failgroup_typefrom v$asm_diskgroup dg, v$asm_disk dwhere dg.group_number = d.group_nu...
原来磁盘信息：
col name format a15;
col path format a30;
col failgroup format a20;
select dg.name, d.path, d.failgroup, d.failgroup_type
from v$asm_diskgroup dg, v$asm_disk d
where dg.group_number = d.group_number and dg.name = 'OCR'
order by dg.name, d.path, d.failgroup;
NAME PATH FAILGROUP FAILGRO
--------------- ------------------------------ -------------------- -------
OCR /dev/oracleasm/disks/OCR01 OCR_0000 REGULAR
OCR /dev/oracleasm/disks/OCR02 OCR_0001 REGULAR
OCR /dev/oracleasm/disks/OCR03 OCR_0002 REGULAR
添加命令：
ALTER DISKGROUP OCR ADD
FAILGROUP OCR_0000 DISK '/dev/oracleasm/disks/OCR101','/dev/oracleasm/disks/OCR102'
FAILGROUP OCR_0002 DISK '/dev/oracleasm/disks/OCR103';
添加之后磁盘信息：
NAME PATH FAILGROUP FAILGRO
--------------- ------------------------------ -------------------- -------
OCR /dev/oracleasm/disks/OCR01 OCR_0000 REGULAR
OCR /dev/oracleasm/disks/OCR02 OCR_0001 REGULAR
OCR /dev/oracleasm/disks/OCR03 OCR_0002 REGULAR
OCR /dev/oracleasm/disks/OCR101 OCR_0000 REGULAR
OCR /dev/oracleasm/disks/OCR102 OCR_0000 REGULAR
OCR /dev/oracleasm/disks/OCR103 OCR_0002 REGULAR
【声明】本内容来自华为云开发者社区博主，不代表华为云及华为云开发者社区的观点和立场。转载时必须标注文章的来源（华为云社区）、文章链接、文章作者等基本信息，否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）