ALTER DISKGROUP DATA DROP DISK 'DATA_0001'; ALTER DISKGROUP DATA ADD DISK '/dev/mapper/asm_data_new' NAME 'DATA_0001'; Error example: Disk path /dev/sdg has invalid permissions (640)
-- Mount the disk group with repair option (requires downtime) ALTER DISKGROUP DATA MOUNT RESTRICT; -- Run ASM Check (from OS) $GRID_HOME/bin/asmcmd md_check DATA -- If errors found: ALTER DISKGROUP DATA CHECK REPAIR; ALTER DISKGROUP DATA DISMOUNT; ALTER DISKGROUP DATA MOUNT; Error example: Attribute 'compatible.asm' value '19.0.0.0.0' higher than software version '12.2.0.1.0' asm health checker found 1 new failures
A healthy ASM is the silent foundation of a robust Oracle database. Listen to its health checker, and your database will thank you with uptime. Have you encountered an unusual "1 new failure" not covered here? Share your specific error message—solutions vary by Oracle version (11.2 to 23ai) and storage vendor. ALTER DISKGROUP DATA DROP DISK 'DATA_0001'; ALTER DISKGROUP
ALTER DISKGROUP DATA SET ATTRIBUTE 'compatible.asm' = '12.2'; After fixing the issue, the ASM health checker will automatically re-evaluate within 1 hour (by default). To force an immediate recheck: Share your specific error message—solutions vary by Oracle
-- 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. Enable ASM Scrub (foreground checking):
If you manage Oracle Grid Infrastructure (GI) or a standalone Automatic Storage Management (ASM) instance, one notification can send a chill down your spine: "ASM health checker found 1 new failures."
If dd fails with "Input/output error", the disk is physically failing. Scenario A: Offline Disk (Most Common) Error example: Disk DATA_0001 is offline