4 Replies Latest reply: Dec 27, 2012 11:35 AM by user3266490 RSS

    Drop disk

    user3266490
      Hi,

      Db :11.2.0.3
      Os:Aix6

      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;
      
           SOFAR EST_MINUTES
      ---------- -----------
               0           0
      But checking in v$asm_disk,it shows state dropping.
      NAME                      PATH                       STATE    MOUNT_S HEADE
      ------------------------- -------------------------- -------- ------- -----
      IT8_ORAGROUP01_0010   /dev/IT8_ORA_DISK2     DROPPING CACHED  MEMBER
      Any suggestions

      Thanks & Regards,
      VN

      Edited by: user3266490 on Dec 26, 2012 1:27 AM
        • 1. Re: Drop disk
          Niket Kumar
          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
            kuljeet singh -
            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.

            http://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm#CHDFJADJ
            • 3. Re: Drop disk
              onedbguru
              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
                Hi,

                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,
                VN