OCRVOTE

select a.group_number,b.name,a.failgroup,a.path
from v$asm_disk a,v$asm_diskgroup b
where a.group_number=b.group_number
and a.group_number=1
order by 3;    

set linesize 300 pages 999
col path for a65
col disk_group_name for a15
col FAILGROUP for a25
col disk_name for a22
select a.group_number ,b.name as disk_group_name ,a.MOUNT_STATUS ,a.HEADER_STATUS ,a.MODE_STATUS ,a.state,a.REDUNDANCY ,a.NAME as disk_name ,a.FAILGROUP ,a.path from v$asm_disk a,v$asm_diskgroup b
where a.group_number=b.group_number
and  a.group_number=1
order by 1,2,6;