###检查diskgroup & disk状态
set linesize 200 pagesize 80
column path format a45
column name format a20
column failgroup format a15
select group_number, disk_number, mount_status, header_status, state, failgroup, name, path from v$asm_disk_stat;
GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU STATE FAILGROUP NAME PATH
------------ ----------- ------- ------------ -------- --------------- -------------------- ---------------------------------------------
1 0 CACHED MEMBER NORMAL SPDG_0000 SPDG_0000 /dev/rhdiskpower0
2 0 CACHED MEMBER NORMAL AJXDG1_0000 AJXDG1_0000 /dev/rhdiskpower12
2 1 CACHED MEMBER NORMAL AJXDG1_0001 AJXDG1_0001 /dev/rhdiskpower13
2 2 CACHED MEMBER NORMAL AJXDG1_0002 AJXDG1_0002 /dev/rhdiskpower14
2 3 CACHED MEMBER NORMAL AJXDG1_0003 AJXDG1_0003 /dev/rhdiskpower15
2 4 CACHED MEMBER NORMAL AJXDG1_0004 AJXDG1_0004 /dev/rhdiskpower16
2 5 CACHED MEMBER NORMAL AJXDG1_0005 AJXDG1_0005 /dev/rhdiskpower17
2 6 CACHED MEMBER NORMAL AJXDG1_0006 AJXDG1_0006 /dev/rhdiskpower18
2 7 CACHED MEMBER NORMAL AJXDG1_0007 AJXDG1_0007 /dev/rhdiskpower19
2 8 CACHED MEMBER NORMAL AJXDG1_0008 AJXDG1_0008 /dev/rhdiskpower20
2 9 CACHED MEMBER NORMAL AJXDG1_0009 AJXDG1_0009 /dev/rhdiskpower21
2 10 CACHED MEMBER NORMAL AJXDG1_0010 AJXDG1_0010 /dev/rhdiskpower22
2 11 CACHED MEMBER NORMAL AJXDG1_0011 AJXDG1_0011 /dev/rhdiskpower23
2 12 CACHED MEMBER NORMAL AJXDG1_0012 AJXDG1_0012 /dev/rhdiskpower24
2 13 CACHED MEMBER NORMAL AJXDG1_0013 AJXDG1_0013 /dev/rhdiskpower25
2 14 CACHED MEMBER NORMAL AJXDG1_0014 AJXDG1_0014 /dev/rhdiskpower26
2 15 CACHED MEMBER NORMAL AJXDG1_0015 AJXDG1_0015 /dev/rhdiskpower27
3 0 CACHED MEMBER NORMAL AJXDG2_0000 AJXDG2_0000 /dev/rhdiskpower28
3 1 CACHED MEMBER NORMAL AJXDG2_0001 AJXDG2_0001 /dev/rhdiskpower29
3 2 CACHED MEMBER NORMAL AJXDG2_0002 AJXDG2_0002 /dev/rhdiskpower30
3 3 CACHED MEMBER NORMAL AJXDG2_0003 AJXDG2_0003 /dev/rhdiskpower31
3 4 CACHED MEMBER NORMAL AJXDG2_0004 AJXDG2_0004 /dev/rhdiskpower32
3 5 CACHED MEMBER NORMAL AJXDG2_0005 AJXDG2_0005 /dev/rhdiskpower33
3 6 CACHED MEMBER NORMAL AJXDG2_0006 AJXDG2_0006 /dev/rhdiskpower34
3 7 CACHED MEMBER NORMAL AJXDG2_0007 AJXDG2_0007 /dev/rhdiskpower35
3 8 CACHED MEMBER NORMAL AJXDG2_0008 AJXDG2_0008 /dev/rhdiskpower36
3 9 CACHED MEMBER NORMAL AJXDG2_0009 AJXDG2_0009 /dev/rhdiskpower37
3 10 CACHED MEMBER NORMAL AJXDG2_0010 AJXDG2_0010 /dev/rhdiskpower38
3 11 CACHED MEMBER NORMAL AJXDG2_0011 AJXDG2_0011 /dev/rhdiskpower39
3 12 CACHED MEMBER NORMAL AJXDG2_0012 AJXDG2_0012 /dev/rhdiskpower40
3 13 CACHED MEMBER NORMAL AJXDG2_0013 AJXDG2_0013 /dev/rhdiskpower41
3 14 CACHED MEMBER NORMAL AJXDG2_0014 AJXDG2_0014 /dev/rhdiskpower42
3 15 CACHED MEMBER NORMAL AJXDG2_0015 AJXDG2_0015 /dev/rhdiskpower43
SQL> select group_number, name, state, type, total_mb, free_mb from v$asm_diskgroup_stat;