3 Replies Latest reply: Jan 8, 2013 6:24 PM by tkanton RSS

    how to remove a disk or diskgroup

    629165
      Without breaking up your db, is there a way to remove a disk or disk group ?

      thanks,
      Chau
        • 1. Re: how to remove a disk or diskgroup
          Murali Vallath
          Offcourse..that is the great feature of ASM.

          You can DROP a disk from an ASM DISKGROUP while the database is online. Please make sure that there is sufficient space available before doing so, because when you DROP the data that resides on this disk are moved by ASM to other available disks in the diskgroup.

          To drop a DISKGROUP, you have to ensure that the data is moved to another diskgroup. If the DISKGROUP is empty, then you can UNMOUNT the DISKGROUP and then DROP it.

          Please follow the Oracle documentation for exact syntax for these operations.
          • 2. Re: how to remove a disk or diskgroup
            251126
            A quick note on the syntax on dropping a disk from a diskgroup, you cannot use the actual lun name, you have to use the name that has been designated in ASM, or you will get an 15054 error when trying to remove the disk.

            From Note: 418980.1
            • 3. Re: how to remove a disk or diskgroup
              tkanton
              I dropped a diskgroup but the disks are still listed in v$asm_disk; the strange thing is that they are associated with disk group 0...see query result:

              SQL> select name,path,group_number from v$asm_disk;

              NAME
              ------------------------------
              PATH
              --------------------------------------------------------------------------------
              GROUP_NUMBER
              ------------

              /opt/NetApp/smo/mnt/-u03-20121224173628148_0/data1
                   0


              /opt/NetApp/smo/mnt/-u03-20121224173628148_0/data2
                   0

              NAME
              ------------------------------
              PATH
              --------------------------------------------------------------------------------
              GROUP_NUMBER
              ------------

              DB1_REDO_0000
              /u05/redo1
                   5

              DB1_REDO_0001
              /u05/redo2

              NAME
              ------------------------------
              PATH
              --------------------------------------------------------------------------------
              GROUP_NUMBER
              ------------
                   5

              DATA_0000
              /u02/data1
                   1

              DATA_0001

              NAME
              ------------------------------
              PATH
              --------------------------------------------------------------------------------
              GROUP_NUMBER
              ------------
              /u02/data2
                   1

              DB1_CONTROL_0001
              /u04/ctl2
                   2


              NAME
              ------------------------------
              PATH
              --------------------------------------------------------------------------------
              GROUP_NUMBER
              ------------
              DB1_CONTROL_0000
              /u04/ctl1
                   2

              FRA_0000
              /u06/fra1
                   6

              NAME
              ------------------------------
              PATH
              --------------------------------------------------------------------------------
              GROUP_NUMBER
              ------------

              FRA_0001
              /u06/fra2
                   6

              DB1_DATA_0001
              /u03/data2

              NAME
              ------------------------------
              PATH
              --------------------------------------------------------------------------------
              GROUP_NUMBER
              ------------
                   4

              DB1_DATA_0000
              /u03/data1
                   4


              12 rows selected.