This alert indicates that the Oracle Automatic Storage Management (ASM)
$ asmcmd health check ... FAILURE: Disk group DATA – Disk DATA_0002 is offline ...
If the SQL diagnostics point to a disk or path failure, move to the operating system level:
The one-line alert is just a header. Immediately examine the ASM alert log for surrounding messages. asm health checker found 1 new failures updated
If the disk group won't mount, use the kfed utility (e.g., kfed read ) to check for corrupted metadata or invalid disk headers.
Query V$ASM_DISK to find disks with a status of OFFLINE or HUNG .
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: This alert indicates that the Oracle Automatic Storage
: Inconsistencies found during a rebalance or an manual ALTER DISKGROUP CHECK operation.
A formal review of this failure should include an investigation of the root cause and an immediate assessment of data risk.
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. Immediately examine the ASM alert log for surrounding
You can run Health Monitor checks automatically using Oracle Enterprise Manager (OEM) or by scheduling a DBMS_HM.RUN_CHECK PL/SQL job. For example, to run a database structure integrity check every Sunday:
This command allows Oracle ASM to automatically fix any errors it can, such as correcting broken metadata pointers or updating stale allocation tables. In practice, executing this command often resolves the alert entirely.
The REPAIR clause instructs Oracle ASM to automatically fix any inconsistencies found during the check process. After running this command, the alert will be resolved, and the disk group will be consistent.
Drop the damaged disk from the ASM diskgroup to allow ASM to rebalance data to surviving disks. Command: ALTER DISKGROUP DROP DISK ; 4. Preventing Future Failures To minimize "1 New Failure" alerts: Monitor Disk IO: Regularly query v$asm_disk_iostat .
The message typically appears in the Oracle Automatic Storage Management (ASM) alert logs when a background check detects a serious issue with disk group availability or redundancy.