Asm Health Checker Found 1 New Failures Guide

SELECT * FROM V$ASM_HEALTH_CHECKER_HISTORY ORDER BY CHECK_TIME DESC FETCH FIRST 10 ROWS ONLY; SELECT * FROM V$ASM_OPERATION WHERE STATE='FAILED';

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'; asm health checker found 1 new failures

PROMPT Pending operations: SELECT * FROM v$asm_operation WHERE state != 'DONE'; SELECT * FROM V$ASM_OPERATION WHERE STATE='FAILED'

sqlplus / as sysasm Check recent failures: asm health checker found 1 new failures