To investigate the failure, follow these steps:
Log into your ASM instance via SQL*Plus as SYSASM to assess the cluster-wide operational health of your storage: asm health checker found 1 new failures
When a physical drive develops bad sectors, or the SAN controller drops a drive configuration, the operating system registers a hard kernel fault. Oracle ASM tracks these via asynchronous write errors ( osderr1 , osderr2 ), prompting the health checker to flag a failure. 2. Storage Area Network (SAN) Disconnects To investigate the failure, follow these steps: Log
This final check ensures the inconsistency has been fully resolved and the disk group is now in a consistent state. The absence of new failure messages in the alert.log confirms a successful resolution. Storage Area Network (SAN) Disconnects This final check
-- Create a daily check script spool asm_health_report.html SELECT * FROM v$asm_health_check WHERE status='FAIL'; spool off -- Email the report via crontab or OEM.
: SELECT name, path, mount_status, header_status, state FROM v$asm_disk;
