This discussion is archived
4 Replies Latest reply: Jun 14, 2013 1:09 AM by Raluce RSS

Drop unmountable ASM disk group

Raluce Newbie
Currently Being Moderated

Hi,

 

I have a problem of one of my ASM disk group. The problem was due to Oracke RAc database uninstallation not properly ended due do network connection problem when i was deinstalling my RAC database in my server (Oracle 11g R2 in Centos 6 using ASM on raw device).

When i deinstall my first installation itwas not done properly and i had to remove all files from Oracle and Grid home to finish the deinstallation but when i tried to install again grid and put OCR in ASM with the same disk partition i got an error of mounting ASM disk group because of the presence of the OCR in the disk partition.

To bypass the problem i was creating new disk partition and do the installation of ASm in this newly created partition and it was working.

Actually i want to reuse this old disk partition to cerate new ASM disk group for my flash recovery and archive log destination but when i invoke ASMCA command it show error in mounting the old OCR diskgroup, it means that the old OCR disk group is still registered in ASM database even it was not configured and this disk group is not mountable.

And when i check the asm_diskgroup tables it seems that this disk group is still register in the system even it was not configured during installation (see command output below):

 

SQL> select substr(dg.name,1,10) AS diskgroup, SUBSTR(d.name,1,12) AS asmdisk, SUBSTR(dg.compatibility,1,12) AS asm_compat, SUBSTR(dg.database_compatibility,1,12) AS db_compat
FROM V$ASM_DISKGROUP dg, v$asm_disk d
where dg.group_number = d.group_number;  2    3

DISKGROUP          ASMDISK               ASM_COMPAT           DB_COMPAT
------------------ --------------------- -------------------- -------------------
DATA               DATA_0000             11.2.0.0.0           10.1.0.0.0
OCR_DISK                                 0.0.0.0.0            0.0.0.0.0
OCR_DISK                                 0.0.0.0.0            0.0.0.0.0

 

SQL> select NAME,STATE,TYPE from V$ASM_DISKGROUP;

NAME                           STATE       TYPE
------------------------------ ----------- ------
OCR_DISK                       DISMOUNTED
DATA                           CONNECTED   EXTERN

 

 

My question is can i remove this disk group from my ASM database and reuse the raw partition to create new disk group from asmca command  without disrupting the actual database configuration ?

If yes, what is the process or command to remove it ?

Another question, can i put archivelog dest and flash recoveryarea into an ASM disk group and how can i proceed.

 

thank you,

 

Raluce.


  • 1. Re: Drop unmountable ASM disk group
    rarain Explorer
    Currently Being Moderated

    Hi,

     

    Did you try this command drop diskgroup <name> force including contents ? Actually when the ASM is started it reads all the disks header located by ASM_DISKSTRING parameter and read the metadata to get the details of disks.

    Another way to get rid of from this problem by formatting the disks using dd command so that ASM metadata get erase from the disk header and ASM won't be able to read those disks. Try this and update the progress...

     

    Thanks

  • 2. Re: Drop unmountable ASM disk group
    Raluce Newbie
    Currently Being Moderated

    Hi

     

    thank you for the replay, when i try the command i got an error below:

     

    SQL> drop diskgroup OCR_DISK force including contents;

    drop diskgroup OCR_DISK force including contents

    *

    ERROR at line 1:

    ORA-15000: command disallowed by current instance type

     

    I change the instance to +ASM1 (export ORACLE_SID=+ASM1) and i connect from sqlplus it says that i'm connected to an idle instance:

     

    [oracle@Etopup-srv01 ~]$ echo $ORACLE_SID
    +ASM1
    [oracle@Etopup-srv01 ~]$ sqlplus

    SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 13 18:07:04 2013

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

    Enter user-name: sys as sysdba
    Enter password:
    Connected to an idle instance.

     

    But when i check the cluster status, ASM service is started:

     

    [grid@Etopup-srv01 ~]$ crs_stat -t -v

    Name           Type           R/RA   F/FT   Target    State     Host

    ----------------------------------------------------------------------

    ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    etop...rv01

    ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    etop...rv01

    ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    etop...rv02

    ora....N2.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    etop...rv01

    ora....N3.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    etop...rv01

    ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    etop...rv01

    ora.eons       ora.eons.type  0/3    0/     ONLINE    ONLINE    etop...rv01

    ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    etop...rv01

    ora....01.lsnr application    0/5    0/0    ONLINE    ONLINE    etop...rv01

    ora....v01.gsd application    0/5    0/0    OFFLINE   OFFLINE

    ora....v01.ons application    0/3    0/0    ONLINE    ONLINE    etop...rv01

    ora....v01.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    etop...rv01

    ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    etop...rv02

    ora....02.lsnr application    0/5    0/0    ONLINE    ONLINE    etop...rv02

    ora....v02.gsd application    0/5    0/0    OFFLINE   OFFLINE

    ora....v02.ons application    0/3    0/0    ONLINE    ONLINE    etop...rv02

    ora....v02.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    etop...rv02

    ora.etopup.db  ora....se.type 0/2    0/1    ONLINE    ONLINE    etop...rv01

    ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE

    ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    etop...rv01

    ora.oc4j       ora.oc4j.type  0/5    0/0    OFFLINE   OFFLINE

    ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    etop...rv01

    ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    etop...rv02

    ora.scan2.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    etop...rv01

    ora.scan3.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    etop...rv01

     

    Could you help what is wrong in my system.

     

    Raluce

  • 3. Re: Drop unmountable ASM disk group
    Raluce Newbie
    Currently Being Moderated

    Hi,

     

    I found the solution for the ASM idle instance error, it's explained in the metalink note below:

    ASM Instance Showing Down In 11g Grid Control With Error ORA-15000 [ID 1276657.1]

     

    Solution

    Use SYSDBA role instead SYSASM role in Monitoring Configuration with: go to the ASM home page -> click on Monitoring Configuration link -> Change the role to SYSDBA -> test the connection and submit the change.

     

     

    Or you can connect by using the following connection string :

     

    sqlplus sys/<password>@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myasmhost)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))" as sysdba;

     

    sqlplus sys/<password>@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myasmhost)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))" as sysasm;

     

    And how about my other quesiton regarding on actovating archive log and moving archive log destination to an ASM disk group.

     

    SQL> archive log list;

    Database log mode              No Archive Mode

    Automatic archival             Disabled

    Archive destination            /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch

    Oldest online log sequence     76

    Current log sequence           77

     

     

     

    Thank you,

     

    Raluce.

  • 4. Re: Drop unmountable ASM disk group
    Raluce Newbie
    Currently Being Moderated

    Hi the permanent solution is to export ORACLE_HOME like this without the / in the end of the path of oracle home:

     

    export ORACLE_HOME=/u01/app/11.2.0/grid  (not  this export ORACLE_HOME=/u01/app/11.2.0/grid/)

     

    regards,

     

    Raluce