This discussion is archived
4 Replies Latest reply: Dec 27, 2012 9:35 AM by user3266490 RSS

Drop disk

user3266490 Newbie
Currently Being Moderated

Db :

We removed a disk from diskgroup.We got estimated minutes 0 When we check in v$asm_operation.
select SOFAR,EST_MINUTES from v$asm_operation;

---------- -----------
         0           0
But checking in v$asm_disk,it shows state dropping.
NAME                      PATH                       STATE    MOUNT_S HEADE
------------------------- -------------------------- -------- ------- -----
Any suggestions

Thanks & Regards,

Edited by: user3266490 on Dec 26, 2012 1:27 AM
  • 1. Re: Drop disk
    Niket Kumar Pro
    Currently Being Moderated
    DROPPING - Disk has been manually taken offline and space allocation or data access for the disk halts. Rebalancing will commence to relocate data off the disks to other disks in the disk group. Upon completion of the rebalance, the disk is expelled from the group.
  • 2. Re: Drop disk
    KuljeetPalSingh Guru
    Currently Being Moderated
    looks ok...wait for few mins and check the status again as once disk will dropped then disk group is rebalanced by moving all of the file extents from the dropped disk to other disks in the disk group.
  • 3. Re: Drop disk
    onedbguru Pro
    Currently Being Moderated
    make sure rebalance power is > 0. How long it takes will depend on your I/O subsystem and rebalance power.
  • 4. Re: Drop disk
    user3266490 Newbie
    Currently Being Moderated

    Thanks for your reply.

    We got the error ORA-04031 in alert log.It's 500gb disk.Now rebalancing is completed.It took 11 hours to complete.

    We dropped the disk by sql*plus.

    When we dropped a disk by OEM,it took less time than sql*plus.Is there any reason?

    Thanks & Regards,


  • Correct Answers - 10 points
  • Helpful Answers - 5 points