WARNING: ASM Health Checker found 1 new failures updated Failure details: Disk group: DATA Disk: DATA_0003 (path: /dev/mapper/data_disk3) Failure type: OFFLINE Timestamp: 2025-01-15T14:23:10 Connect to your ASM instance using sqlplus / as sysasm and run the following diagnostic queries:
Stay proactive, monitor your disk groups regularly, and your ASM health checker will reward you with silence—the best alert of all. ASM Health Checker found 1 new failures updated, ASM alert log, Oracle ASM troubleshooting, disk group failure, v$asm_diskgroup, offline disks, ASM metadata corruption, multipath failure, Oracle RAC health check.
SELECT group_number, disk_number, name, path, state, mode_status, failgroup FROM v$asm_disk WHERE state != 'NORMAL'; Disks in FORCING state (attempting recovery) or OFFLINE state are the culprits. asm health checker found 1 new failures updated
Introduction If you are an Oracle Database Administrator (DBA) managing an Oracle Real Application Clusters (RAC) environment, you have likely encountered a cryptic but critical message in your alert logs or monitoring console: "ASM Health Checker found 1 new failures updated."
SELECT * FROM v$asm_disk_iostat WHERE read_errs > 0 OR write_errs > 0 OR bytes_read = 0; WARNING: ASM Health Checker found 1 new failures
Remember: Ignoring the alert can lead to a cascade of failures, especially in lower redundancy configurations. With the diagnostic steps and remediation strategies provided in this guide, you can confidently resolve the alert and restore your ASM environment to full health.
SELECT name, state, type, total_mb, free_mb, offline_disks FROM v$asm_diskgroup; If offline_disks > 0, you have confirmed physical disk failures. Introduction If you are an Oracle Database Administrator
This comprehensive guide will dissect every aspect of this error message. We will explore what the ASM Health Checker is, why it triggers this alert, how to diagnose the specific failure, and step-by-step remediation strategies. The ASM Health Checker is an internal diagnostic tool embedded within Oracle ASM (introduced in Oracle 11g Release 2 and enhanced in 12c, 18c, 19c, and 21c). Its primary function is to periodically validate the integrity, accessibility, and configuration of ASM disk groups and their underlying disks.