7 Replies Latest reply on Dec 5, 2012 1:41 PM by nnarimanov

    ASM instance Verification

      Hi Team,

      Let i have 5 databases, 3 running with ASM and 2 are not in ASM. How i check in a single go, which is running in ASM ans which is not in ASM?
        • 1. Re: ASM instance Verification
          Levi Pereira
          Query on v$controlfile, v$datafile, v$tempfile, v$logfile, v$block_change_tracking and "show parameter db_recovery_file_dest, spfile" of each database.
          • 2. Re: ASM instance Verification
            As my knowledge using

            $ORACLE_HOME/bin/./srvctl status ASM

            we can check the asm is running or not for a database.

            But my question is how we can check for 5 database at a time in LINUX environment.
            Is there any specific command to check that?
            • 3. Re: ASM instance Verification
              Levi Pereira
              There is no command to show what Database have files actives on ASM.

              You can place on ASM only one File(like SPFILE) and the others on Filesystem.

              And on ASM you can see some directory of that database but you don't have sure if it is used or not, some database are migrated from ASM to filesystem and the DBA dont remove the files of ASM.

              The only way to know if that database have files on ASM or not is checking V$ of Database to see where is store these files.

              Using ASMCMD utilty and command "lsct" you will get who (Database and others resource) is currently connect on ASM.

              Levi Pereira

              Edited by: Levi Pereira on Sep 20, 2012 3:57 PM
              1 person found this helpful
              • 4. Re: ASM instance Verification
                For this u have to manully login in to ur DB and check through
                select name from v$datafile;
                • 5. Re: ASM instance Verification
                  the datailfe, controlfile and sp parameters are obviously the defacto ways to get that infor but if the controlfile, FRA or spfile is located on ASM it will show up in the alert log at start time. Use the tac command to read from bottom of file. this will give you the last time the database was started. assuming of course you still have that info in the alert log and it hasnt been wiped/truncated/archived since last start.

                  cd to bdump and run following, obviously passing in your own alert log

                  tac alert_<sid>.log | egrep -i "db_create_file_dest|control_files|spfile" | more
                  • 6. Re: ASM instance Verification
                    Log into the ASM instance and query the view v$ASM_CLIENT
                    • 7. Re: ASM instance Verification
                      It's true for 11g
                      ASMCMD> lsct -g