This discussion is archived
5 Replies Latest reply: Jan 10, 2013 2:59 AM by 486778 RSS

How to drop one disk from diskgroups(contain 2 disk) in two node RAC ASM ?

879152 Newbie
Currently Being Moderated
I am using Oracle 11g R2 database and asm.

I have created one diskgroups name DATA which contain two disks ( data1 and data2).
RAC is up and running. Now I want to drop one disk name data2 from diskgroups DATA
without losing data.

Please any one give me process of this.


Thanks
Solaiman
  • 1. Re: How to drop one disk from diskgroups(contain 2 disk) in two node RAC ASM ?
    861120 Explorer
    Currently Being Moderated
    Hi

    Please:
    SQL> select group_number,name from v$asm_diskgroup;
    
    GROUP_NUMBER             NAME
    --------------------------             ----------
    1                                            DATA
    
    
    SQL> select path,name from v$asm_disk where group_number=1;
    
    PATH NAME
    —
    /dev/raw/raw5 DATA_01
    /dev/raw/raw6 DATA_02
    
    SQL> alter diskgroup DATA drop disk DATA_01;
    
    Diskgroup altered.
    And wait finish the ASM operation
    SQL> select * from v$asm_operation;
    
    GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE  EST_MINUTES
    ------------ ----- ---- ----- ----- ------ -------  ---------- ---------- 
            1 REBAL RUN     1      1   100   42234       1007     41 
    To do this, your diskgroup need be external type redundancy.

    Edited by: Flávio Soares on Jan 8, 2013 10:33 AM
  • 2. Re: How to drop one disk from diskgroups(contain 2 disk) in two node RAC ASM ?
    879152 Newbie
    Currently Being Moderated
    Hi,

    Thanks for reply.

    Shall I do it in one node or both node?
    Since I am using two node RAC ASM and external redundancy.


    Thanks
    Solaiman
  • 3. Re: How to drop one disk from diskgroups(contain 2 disk) in two node RAC ASM ?
    KuljeetPalSingh Guru
    Currently Being Moderated
    you need to drop it from one node only.

    during drop disk oracle will move all data from this disk into 1st available disk if it can't then you will not able to drop this disk.
  • 4. Re: How to drop one disk from diskgroups(contain 2 disk) in two node RAC ASM ?
    614002 Newbie
    Currently Being Moderated
    Yes .

    you can do that at one node , but pls ensure remain disks have enough space for all contents of database.
  • 5. Re: How to drop one disk from diskgroups(contain 2 disk) in two node RAC ASM ?
    486778 Newbie
    Currently Being Moderated
    What type of redundancy do you have configured for your disks? There is a difference with how Oracle places files on the disks if the diskgroup is configured with normal/high redundancy or if it is configured with external redundancy? You can find that out by using the script below:

    select GROUP_NUMBER,NAME,STATE,TYPE,TOTAL_MB,FREE_MB,USABLE_FILE_MB,OFFLINE_DISKS,DATABASE_COMPATIBILITY from V$ASM_DISKGROUP order by 1

    or you can use the following to get the disks associated with a particular diskgroup

    set verify off
    set verify off
    set line 950
    col GRP_NUM format a5
    col DSK_NUM format a5
    col PATH format a50
    col NAME format a22
    col TOTAL_MB heading 'TOTAL(MB)' format 9,999,999
    col FREE_MB heading 'FREE(MB)' format 9,999,999
    set pagesize 999
    select to_char(GROUP_NUMBER) GRP_NUM,to_char(disk_number) DSK_NUM,MOUNT_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH from V$ASM_DISK
    where GROUP_NUMBER in(select GROUP_NUMBER from V$ASM_DISKGROUP
    where NAME = upper('&Disk_Group_Name'))
    order by 1,2;


    Cheers
    Samuel

Legend

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