4 Replies Latest reply: Dec 11, 2012 10:13 AM by Levi Pereira RSS

    Drop diskgroup ASM 11.2

    User477708-OC
      having reviewed thread here
      what is the correct procedure to drop asm diskgroup is rac?

      Ive found many docs and pointers on how to drop asm groups. sqlplus in asm, asmca, EM. either ones will work. I chose sqlplus "drop diskgroup". no problem, it worked, however, my RAC is complaining, the diskgroup that i dropped is still listed as a resource.

      Ok, i can run srvctl modify resource and drop it.

      Question then is, is there one command that I can run which will do both? drop the diskgroup AND as a RAC resource.
        • 1. Re: Drop diskgroup ASM 11.2
          Levi Pereira
          Hi,

          If you use SQLPLUS to drop Diskgroup you must to use "srvctl remove diskgroup -g" to remove diskgroup from OCR.

          If you use ASMCA one step remove both.

          No, there is no one command to do it.... but is easy with 4 command.
          e.g:
          oracle@node1 > sqlplus / as sysasm
          SQL>  sqlplus / as sysasm
          
          SQL> ! srvctl status diskgroup -g DATA
          Disk Group DATA is running on node1,node2,node3
          
          SQL> ! srvctl stop diskgroup -g DATA -n node2,node3
          
          SQL> DROP DISKGROUP DATA;
          
          SQL >  ! srvctl remove diskgroup -g DATA 
          • 2. Re: Drop diskgroup ASM 11.2
            User477708-OC
            thanks Levi, clear as always. Is there any reason why you left node 1 out of the node list in the stop diskgroup command above?
            • 3. Re: Drop diskgroup ASM 11.2
              LaserSoft
              Hi

              Good Query and Good Finding.

              On release 11.2.0.2, after drop a diskgroups ASM is not releasing file descriptors on the raw devices.

              Document 4693355.8 states that this problem (Bug:4693355 & Bug:7225720) is fixed on release 11.2.0.1.0, but the problem persists on release 11.2.0.2.0. Even if DROP DISKGROUP or DISMOUNT DISK GROUP scenarios.

              Example : $ asmcmd
              ASMCMD> dropdg -r DATADG

              Oracle Recommends :

              A) DROP DISKGROUP SCENARIO:

              Apply Patch:11785938

              B) DISMOUNT DISKGROUP SCENARIO:

              Apply Patch:11666137


              *More Details : please look "ASM 11.2.0.2 Is Not Releasing File Descriptors After Drop or Dismount Diskgroup. [ID 1306574.1]"*

              Thanks
              LaserSoft
              • 4. Re: Drop diskgroup ASM 11.2
                Levi Pereira
                961469 wrote:
                thanks Levi, clear as always. Is there any reason why you left node 1 out of the node list in the stop diskgroup command above?
                Yes, to drop a diskgroup it must be mounted only on node which you will issue "drop" command. ( i.e you can't drop a diskgroup dismounted)

                Regards,
                Levi Pereira