3 Replies Latest reply: Apr 17, 2014 9:04 AM by kazyskiyn0w RSS

    Diskgroup resize

    kazyskiyn0w

      Hi All,

      Is it possible to resize a diskgroup after it has been created and configures for a database?

      for instance, I have a diskgroup DGDATA1 with 800GB. Is it possible to release 200GB from DGDATA1 , and create another small diskgroup DGDATA2 to use the space realeased 200GB?

       

      thanks

      Kz

        • 1. Re: Diskgroup resize
          Tom321

          Hi,

           

          if you have more than one disk mounted in that diskgroup it is easy. Lets say you have 4 Disks with 200GB, then you can drop one of the disks out of the group. ASM will rebalance the data on the other 3 disks in the group and then release the disk. The free disk can be reused in a smaller diskgroup.

          If the 800 GB are a single disk/LUN you need do add a new 600GB disk to the asm group and drop the existing one. ASM will move the data from old to new disk during the operation. Breaking up the large 800GB disk into smaller fractions would be the next step before creating a new smaller group.

           

          Regards

          Thomas

          • 2. Re: Diskgroup resize
            Emad Al-Mousa

            Hi,

             

            yes,

            "you can use the ALTER DISGROUP statement to alter a disk group configuration. you can add,resize,or drop disks while the database remains online. Whenever possible,multiple operations in a single ALTER DISKGROUP statemetn are recommended. ASM automatically reblances when the configuration of a disk group changes. By default, the ALTER DISKGROUP statement does not wait until the operation is complete before returning. Query the V$ASM_OPERATION view to monitor the status of this operation".

             

            source: http://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm#CHDFIHHC

             

            Regards,

            • 3. Re: Diskgroup resize
              kazyskiyn0w

              Thanks Tom and Emad for your replies, very useful.