Health Checker Found 1 New Failures Updated | Asm

SELECT group_number, disk_number, name, path, state, mode_status, failgroup FROM v$asm_disk WHERE state != 'NORMAL'; Disks in FORCING state (attempting recovery) or OFFLINE state are the culprits.

At first glance, this message can induce panic. Does it mean data loss? Is your disk group about to crash? Will your production database go offline? Fortunately, in most cases, this alert is a proactive warning from Oracle’s Automatic Storage Management (ASM) diagnostics framework. However, ignoring it can lead to severe performance degradation or service interruption. asm health checker found 1 new failures updated

ALTER DISKGROUP data SET ATTRIBUTE 'disk_repair_time' = '6h'; Schedule weekly manual checks using: in most cases

SELECT name, state, type, total_mb, free_mb, offline_disks FROM v$asm_diskgroup; If offline_disks > 0, you have confirmed physical disk failures. offline_disks FROM v$asm_diskgroup