<<Back to Oracle ASM Main Page Adding Dropped Disks Back into Diskgroup The steps documented in this post is helpful if you have dropped disks which is still hanging and ASM.repair_time parameter is already over. Further select * from v$asm_operations shows error. Although the disk is still showing dropping but if you try to bring it online it fails. If you try to force drop it, it fails. Step 1: Identify the missing/dropped disk for a particular disk group select GROUP_NUMBER,NAME from v$asm_diskgroup; select name,header_status,mount_status,path from v$asm_disk where GROUP_NUMBER=2; Step2: Find ASM disk level for each dropped disks A> Scan ASM log file for this info B> Check output of MD_BACKUP before the issue In my case it was FRA_01 Diskgroup where one of storage site went down causing the issue. After scanning ASM alertlog I found the following ASM disks which were part of the ASM Disk group but Currently these are the disks which is appearing as dropping. fail
A Blog to share interesting Database Facts and Experience.