SELECT group_number, name, path, state, failgroup, mode_status FROM v$asm_disk WHERE state != 'NORMAL';
SELECT path, disk_number, header_status, state, mount_status FROM v$asm_disk WHERE group_number = (SELECT group_number FROM v$asm_diskgroup WHERE name = 'YOUR_DISKGROUP'); Use code with caution. 4. Verify Physical Connectivity (OS Level)
SQL> ALTER DISKGROUP <disk_group_name> CHECK;
SELECT group_number, name, path, state, failgroup, mode_status FROM v$asm_disk WHERE state != 'NORMAL';
SELECT path, disk_number, header_status, state, mount_status FROM v$asm_disk WHERE group_number = (SELECT group_number FROM v$asm_diskgroup WHERE name = 'YOUR_DISKGROUP'); Use code with caution. 4. Verify Physical Connectivity (OS Level)
SQL> ALTER DISKGROUP <disk_group_name> CHECK;