SELECT * FROM v$asm_diskgroup_stat; No rows selected
For some systen with ASM 11.2.0.4 oracle we are not getting output for
select 'DATA' dum1, free_mb/decode(type, 'NORMAL', 2,'HIGH' , 3, 'EXTERN', 1) SPACE_AVAIL, (total_mb - free_mb) SPACE_USED from v$asm_diskgroup_stat where name = 'DATA_QA' and (state= 'MOUNTED' OR state= 'CONNECTED');
I have found some online doc http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG94121 explaining about discovery "How A Disk is Discovered" Will this be useful ?
Also there is BLOG available on this issue http://www.killdb.com/2011/10/10/oracle-restart%E4%BD%93%E9%AA%8C%EF%BC%88%E7%BB%AD%EF%BC%89.html