This content has been marked as final. Show 2 replies
You can test V$ASM_DISK.STATE for each disk belonging to the disk group (see http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_1024.htm#I1030170): if each disk has status NORMAL then the disk group should not be in "degraded mode" due to a disk that is currently dropped:1 person found this helpful
For other cases like added disks you should check that there is no ongoing rebalance operation with:
select dg.name, d.name, d.state from v$asm_diskgroup dg, v$asm_disk d where dg.group_number = d.group_number and dg.name='<disk group name>';
Edited by: P. Forstmann on 22 avr. 2013 15:23
select count(*) from v$asm_operation;
Thanks! It is surprising though that there is no simple indicator for such a basic thing.