Asm Health Checker: Found 1 New Failures

SET PAGES 500 COL NAME FOR A20 COL PATH FOR A40 COL FAILURE_REASON FOR A50 PROMPT Current ASM disk health: SELECT name, path, state, header_status, mount_status, failgroup FROM v$asm_disk WHERE header_status != 'MEMBER' OR state != 'NORMAL';

But —they often lead to DG dismounts. 7. Sample Diagnostic Script Save as asm_health_check.sql : asm health checker found 1 new failures

sqlplus / as sysasm Check recent failures: SET PAGES 500 COL NAME FOR A20 COL