Checker Found 1 New Failures Updated — Asm Health
SELECT * FROM v$asm_disk_iostat WHERE read_errs > 0 OR write_errs > 0 OR bytes_read = 0;
SQL> ALTER DISKGROUP <disk group name> CHECK ALL NOREPAIR;
Query V$ASM_DISK to find disks with a status of OFFLINE or HUNG .
For a thorough scan, you can also run:
Implement automated parsing of the ASM alert log to catch health checker messages as soon as they occur, allowing you to respond before the problem escalates.
When managing Oracle Grid Infrastructure, encountering the alert in your Automatic Storage Management (ASM) alert logs signifies a critical event. This warning indicates that an internal ASM process has detected a severe infrastructure issue, typically involving unreadable disk headers, dropped disks, forced dismounts, or storage path loss . If left unresolved, this state can lead to database crashes, corrupted disk groups, and data unavailability. 🛠️ Root Causes of the Alert
The resolution depends entirely on the root cause. Below are the most common fixes. asm health checker found 1 new failures updated
Oracle stores all health checker runs in dynamic performance views. To identify which health check reported the failure, query V$HM_RUN :
Too many offline disks in the PST disable the read quorum, triggering a forced dismount.
The exact path might vary depending on your Oracle version and installation, but the alert/log.xml location is standard in recent Grid Infrastructure versions. SELECT * FROM v$asm_disk_iostat WHERE read_errs > 0
If you see this message, follow these steps to identify and resolve the failure:
SQL> SET LONG 100000; SQL> SET LONGCHUNKSIZE 1000; SQL> SELECT DBMS_HM.GET_RUN_REPORT('HM_RUN_XXXXX') FROM DUAL;
