–weryfikacja czy dyski są niedostępne / wylecialy (kolumna Offline_disks)
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
…
MOUNTED NORMAL N 512 4096 1048576 3145725 75745 1048575 -486415 3 N DATA/
— sprawdzamy jakie poleciały
SQL> select name,failgroup,state from v$asm_disk a where state <> 'NORMAL’;
NAME FAILGROUP STATE
_DROPPED_0002_DATA DATAFG1 FORCING
_DROPPED_0001_DATA DATAFG1 FORCING
_DROPPED_0000_DATA DATAFG1 FORCING…