This discussion is archived
3 Replies Latest reply: Jan 8, 2013 4:24 PM by 701770 RSS

how to remove a disk or diskgroup

629165 Newbie
Currently Being Moderated
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
    MuraliVallath Oracle ACE Director
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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
    701770 Newbie
    Currently Being Moderated
    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.