4 Replies Latest reply: Apr 15, 2013 9:04 AM by Levi Pereira RSS

    status of ASM instance

    Santosh Pradhan
      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
          Mahir M. Quluzade
          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
            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
              Mahir M. Quluzade
              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
                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}