Database Administration Team / System Health Monitoring Group Date: [Insert Date] Priority: Medium

This alert is rarely an isolated software bug. It is almost always a structural or mechanical storage event. 1. Hard I/O Block Failures

Query the V$ASM_DISK view to check disk headers.

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

This is the standard SQL command for triggering an ASM disk group consistency check.

Loss of physical fiber channel paths, faulty host bus adapters (HBAs), or incorrect multipathing layers ( multipathd ) will drop the physical storage paths. ASM detects this loss of communication as a failed disk heartbeat. 3. Disk Header Mutilation

This message, often found in your alert log, crsd.log , or email alerts from Enterprise Manager (EM12c/13c), indicates that the automated ASM Health Checker has detected a new issue affecting the integrity, availability, or performance of your ASM environment. Ignoring it is not an option; unresolved failures can lead to disk group mount issues, I/O latency, or even database crashes.

When any test returns a "FAIL" status, the health checker logs a failure count increment. The message asm health checker found 1 new failures means exactly that: since the last run, the checker identified one more problem than before.

If your health checker runs inside a private VPC subnet, it cannot access the public AWS Secrets Manager endpoint without proper routing.

Once the underlying storage, network, or metadata anomaly is resolved, verify that the health checker returns a clean status.

Inability to write heartbeats to the Primary Status Table (PST) located on the ASM disks, leading to an immediate "dirty detach" process. Step-by-Step Triage and Diagnostics

Once you’ve identified the Failure ID in ADRCI , you can ask Oracle for a repair advice: advise failure ; Use code with caution.

-- Check detailed status of all disks in all disk groups SELECT group_number, disk_number, name, path, state, mode_status, header_status, total_mb, free_mb FROM v$asm_disk;