5 Replies Latest reply: Jan 10, 2013 4:59 AM by 486778 RSS

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

    879152
      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
          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
            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 ?
              kuljeet singh -
              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
                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
                  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