If you've received a notification that the "ASM health checker found 1 new failures updated," it's essential to understand what this message means and take prompt action to resolve the issue. In this article, we'll delve into the details of ASM health checking, explore the possible causes of this error, and provide step-by-step guidance on how to troubleshoot and fix the problem.
A disk was dropped or taken offline due to I/O errors, but the redundancy (if using Normal or High redundancy) kept the database running. Step-by-Step Resolution Guide 1. Identify the Specific Failure
The alert indicates that Oracle Automatic Storage Management Cluster Health Check (AMCHC) or Oracle Autonomous Health Framework (AHF) has detected a new hardware, configuration, or disk failure within your Oracle Grid Infrastructure environment.
asmcmd health check
The Health Checker warning is an outcome, not the source error. You must inspect the ASM trace and alert logs to find out exactly what happened seconds before the failure was printed. KB88485 - My Oracle Support
The most common cause. If an ASM disk becomes inaccessible due to:
. This is often triggered when a monitored resource crosses a predefined threshold or a critical daemon stops responding. Immediate Review Checklist To review and resolve this failure, follow these steps: Identify the Failure Source : Navigate to Security > Reporting > Settings > ASM Alerts asm health checker found 1 new failures updated
If the corruption affects specific database files—such as data files or control files—you may need to restore them from a backup. Use RMAN to restore the affected files:
Understanding the ASM Health Checker Warning The message is a critical alert generated by the Oracle Automatic Storage Management Cluster File System (ACFS) or Oracle Grid Infrastructure health framework.
Temporary SAN outages, faulty Host Bus Adapters (HBAs), or bad network switches can break communication lines between the ASM instance and the physical LUNs. If you've received a notification that the "ASM
ls -al /dev/oracleasm/disks/ # Or for UDEV: ls -al /dev/mapper/ Use code with caution.
SQL> SELECT operation, state, power, est_minutes FROM v$asm_operation; Use code with caution. Scenario C: Permissions and Ownership Resets
ASM> ALTER SYSTEM CHECK HEALTH;
However, the existence of the alert raises a philosophical question about the nature of modern system administration: the reliance on automation. The ASM Health Checker is an automated agent. It runs silently in the background, parsing logs and checking parameters. When it outputs this alert, it is effectively handing off responsibility. The system has detected a fault that it cannot resolve on its own. This moment defines the role of the modern DBA—not as a mere operator who restarts services, but as a diagnostician who must interpret the automated findings.