| ID | Requirement | |----|--------------| | FR1 | System must track the state of each ASM health check item across runs | | FR2 | Detect difference between current_failures and previous_failures | | FR3 | If new_failures_count > 0 , trigger a notification | | FR4 | Include in alert: failure name, timestamp, component, severity (if available) | | FR5 | Suppress duplicate alerts for same failure unless it re-occurs after being resolved |
Leo sighed, rubbing the sleep from his eyes. In the world of Application Services Management, "one new failure" was rarely just one thing. It was a thread. If you pulled it, the whole sweater might come apart.
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. asm health checker found 1 new failures
The ASM Health Checker is an automated diagnostic framework embedded within Oracle Grid Infrastructure. It runs periodic background assessments on crucial storage components, including:
Slow response times from disks that exceed ASM's internal thresholds, forcing ASM to forcefully drop the disk to preserve cluster integrity. | ID | Requirement | |----|--------------| | FR1
The V$ASM_OPERATION view displays rows for every active, long-running operation in the ASM instance, including rebalances. If one is in progress, a query like SELECT * FROM V$ASM_OPERATION WHERE OPERATION LIKE 'REBAL' can show its current STATE (e.g., RUN or WAIT), progress, and estimated time to completion.
WARNING: Offline of disk 3 (LOGA2) in group 2 failed on ASM inst 1. ERROR: ORA-15130: diskgroup "LOG" is being dismounted. ASM Health Checker found 1 new failures. Use code with caution. 2. Storage Heartbeat Failures and Timeouts If you pulled it, the whole sweater might come apart
stat /dev/mapper/asm_data2
The DBMS_HM.GET_RUN_REPORT function returns a detailed report, including the specific Finding Name (e.g., "System datafile is old"), its Type (e.g., FAILURE), Priority (e.g., CRITICAL or HIGH), and a descriptive message. This report is invaluable for understanding the exact nature of the problem.
The most frequent culprit. One disk in a disk group has been taken offline due to:
Validates that ASM metadata mirrors across redundancy sets.