oracle asm 磁盘组信息查询相关sql
【摘要】 查询磁盘空间情况：COL NAME FORMAT a20;col path format a50;select name,path,STATE,free_mb,total_mb from v$asm_disk;NAME PATH STATE FREE_MB ...
查询磁盘空间情况：
COL NAME FORMAT a20;
col path format a50;
select name,path,STATE,free_mb,total_mb from v$asm_disk;
NAME PATH STATE FREE_MB TOTAL_MB
-------------------- -------------------------------------------------- -------- ---------- ----------
/dev/rhdisk22 NORMAL 0 0
/dev/rhdisk23 NORMAL 0 0
/dev/rhdisk24 NORMAL 0 0
/dev/rhdisk19 NORMAL 0 0
/dev/rhdisk20 NORMAL 0 0
/dev/rhdisk21 NORMAL 0 0
/dev/rhdisk26 NORMAL 0 0
/dev/rhdisk25 NORMAL 0 0
OCRVOTE_0002 /dev/rhdisk10 NORMAL 4870 5120
OCRVOTE_0003 /dev/rhdisk11 NORMAL 4870 5120
OCRVOTE_0004 /dev/rhdisk12 NORMAL 4868 5120
ARCH_0000 /dev/rhdisk13 NORMAL 392072 614400
REDO01_0000 /dev/rhdisk2 NORMAL 102305 102400
REDO02_0000 /dev/rhdisk3 NORMAL 102305 102400
DATA_0000 /dev/rhdisk4 NORMAL 466740 614400
DATA_0001 /dev/rhdisk5 NORMAL 466741 614400
DATA_0002 /dev/rhdisk6 NORMAL 466741 614400
DATA_0003 /dev/rhdisk7 NORMAL 466741 614400
OCRVOTE_0000 /dev/rhdisk8 NORMAL 4868 5120
OCRVOTE_0001 /dev/rhdisk9 NORMAL 4868 5120
DATA_0008 /dev/rhdisk15 DROPPING 502091 614400
DATA_0009 /dev/rhdisk16 DROPPING 502089 614400
DATA_0010 /dev/rhdisk17 DROPPING 502090 614400
DATA_0011 /dev/rhdisk18 DROPPING 502088 614400
查看磁盘组相关信息：
set linesize 1000;
set pagesize 5000;
col name format a15;
col path format a30;
col failgroup format a20;
select dg.name,d.STATE,d.path, d.failgroup, d.failgroup_type
from v$asm_diskgroup dg, v$asm_disk d
where dg.group_number = d.group_number
order by dg.name, d.path, d.failgroup;
NAME STATE PATH FAILGROUP FAILGRO
--------------- -------- ------------------------------ -------------------- -------
ARCH NORMAL /dev/rhdisk13 ARCH_0000 REGULAR
DATA DROPPING /dev/rhdisk15 DATA_0008 REGULAR
DATA DROPPING /dev/rhdisk16 DATA_0009 REGULAR
DATA DROPPING /dev/rhdisk17 DATA_0010 REGULAR
DATA DROPPING /dev/rhdisk18 DATA_0011 REGULAR
DATA NORMAL /dev/rhdisk4 DATA_0000 REGULAR
DATA NORMAL /dev/rhdisk5 DATA_0001 REGULAR
DATA NORMAL /dev/rhdisk6 DATA_0002 REGULAR
DATA NORMAL /dev/rhdisk7 DATA_0003 REGULAR
OCRVOTE NORMAL /dev/rhdisk10 OCRVOTE_0002 REGULAR
OCRVOTE NORMAL /dev/rhdisk11 OCRVOTE_0003 REGULAR
OCRVOTE NORMAL /dev/rhdisk12 OCRVOTE_0004 REGULAR
OCRVOTE NORMAL /dev/rhdisk8 OCRVOTE_0000 REGULAR
OCRVOTE NORMAL /dev/rhdisk9 OCRVOTE_0001 REGULAR
REDO01 NORMAL /dev/rhdisk2 REDO01_0000 REGULAR
REDO02 NORMAL /dev/rhdisk3 REDO02_0000 REGULAR
【版权声明】本文为华为云社区用户原创内容，转载时必须标注文章的来源（华为云社区）、文章链接、文章作者等基本信息， 否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）