This discussion is archived
4 Replies Latest reply: Apr 15, 2013 7:04 AM by Levi-Pereira RSS

status of ASM instance

Santosh Pradhan Explorer
Currently Being Moderated
Hi ,
when i fired
select status, instance_name from v$instance ;

started ASM+

my all diskgroups are mounted ...

from above input i have following consideration ...
1.ASM instance is always in NOMOUNT stage(as it is having only one stage to go ) but it mounts all the disks and it is available(Read,write) for database...


PLZ correct me if i m wrong.......
  • 1. Re: status of ASM instance
    MahirM.Quluzade Guru
    Currently Being Moderated
    Santosh Pradhan wrote:
    Hi ,
    when i fired
    select status, instance_name from v$instance ;

    started ASM+

    my all diskgroups are mounted ...

    from above input i have following consideration ...
    1.ASM instance is always in NOMOUNT stage(as it is having only one stage to go ) but it mounts all the disks and it is available(Read,write) for database...


    PLZ correct me if i m wrong.......
    Hi, did you are using RAC? Or you are installed standalone?

    ASM instance is mounted, it means all disk groups is mounted.
    If diskgroups is mounted then ASM Instance is mount state.

    Can you paste here result of ,
     export ORACLE_SID=+ASM
     sqlplus / as sysasm
     sql> select instance_name, status from v$instance; 
    Mahir
  • 2. Re: status of ASM instance
    Santosh Pradhan Explorer
    Currently Being Moderated
    SQL> select instance_name, status from v$instance;

    INSTANCE_NAME STATUS
    ---------------- ------------
    +ASM                  STARTED


    SQL> select NAME,STATE,TOTAL_MB from v$asm_diskgroup ;

    NAME STATE TOTAL_MB
    ------------------------------ ----------- ----------
    DISK_DATA MOUNTED 3072000
    REDO_CTL MOUNTED 20480


    Thanx for answer,,

    Not using RAC

    Ya u r right ,,,
    But wht , when anyone asks , ASM instance in which stage?

    .,,,
    wht should be the answer..
    Mounted or nomounted
  • 3. Re: status of ASM instance
    MahirM.Quluzade Guru
    Currently Being Moderated
    You can check status of instance from v$instance: http://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_2002.htm
    STATUS     VARCHAR2(12)     Status of the instance:
                                      STARTED - After STARTUP NOMOUNT
                                      MOUNTED - After STARTUP MOUNT or ALTER DATABASE CLOSE
                                      OPEN - After STARTUP or ALTER DATABASE OPEN
                                      OPEN MIGRATE - After ALTER DATABASE OPEN { UPGRADE | DOWNGRADE }
    STARTED it means your instance in NOMOUNT mode.


    It is interesting situation.

    Regards
    Mahir M. Quluzade
  • 4. Re: status of ASM instance
    Levi-Pereira Guru
    Currently Being Moderated
    Santosh Pradhan wrote:
    Hi ,
    when i fired
    select status, instance_name from v$instance ;

    started ASM+

    my all diskgroups are mounted ...

    from above input i have following consideration ...
    1.ASM instance is always in NOMOUNT stage(as it is having only one stage to go ) but it mounts all the disks and it is available(Read,write) for database...
    Read it:

    {message:id=10389232}

Legend

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