This method is recommended in Oracle documentation for identifying specific health check failures.
Slow response times from disks that exceed ASM's internal thresholds, forcing ASM to forcefully drop the disk to preserve cluster integrity.
This documentation aids future troubleshooting and contributes to your organization's collective operational intelligence. asm health checker found 1 new failures
SET LONG 100000 SET LONGCHUNKSIZE 1000 SELECT DBMS_HM.GET_RUN_REPORT('HM_RUN_1061') FROM DUAL;
:
In cases of severe block corruption where the database cannot be recovered via standard means, you may need to recreate the diskgroup and restore from backup.
-- 1. Identify the recent health checks SET LINESIZE 200 PAGESIZE 100 COLUMN name FORMAT a20 COLUMN check_name FORMAT a30 COLUMN start_time FORMAT a30 COLUMN end_time FORMAT a30 SELECT run_id, name, check_name, TO_CHAR(start_time, 'YYYY-MM-DD HH24:MI:SS') AS start_time, TO_CHAR(end_time, 'YYYY-MM-DD HH24:MI:SS') AS end_time, status FROM v$hm_run WHERE check_name LIKE '%ASM%' OR name LIKE 'HM_RUN_%' ORDER BY start_time DESC; This method is recommended in Oracle documentation for
Use the following SQL command in the ASM instance to identify disks with red flags (e.g., OFFLINE , CLOSED , or MISSING ):
This error indicates that an automated health check—typically executed via an AWS Lambda function, an Amazon Route 53 health check, or a synthetic monitoring tool—attempted to validate the accessibility, rotation status, or integrity of a secret and failed. Direct Root Causes SET LONG 100000 SET LONGCHUNKSIZE 1000 SELECT DBMS_HM
To resolve the issue, follow these step-by-step instructions:
In cloud or virtualized infrastructure, an underlying network flap can interrupt multipath software (e.g., Device Mapper Multipath). If all redundant paths to a LUN drop simultaneously, ASM interprets this block-level device vanishing act as a device failure. ASM-ALERTLOG-Output-Failure-CELLI03-and-CELL01