This discussion is archived
7 Replies Latest reply: Dec 5, 2012 5:41 AM by nnarimanov RSS

ASM instance Verification

963405 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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
    963405 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    Hi,
    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.


    HTH,
    Levi Pereira

    Edited by: Levi Pereira on Sep 20, 2012 3:57 PM
  • 4. Re: ASM instance Verification
    974842 Newbie
    Currently Being Moderated
    For this u have to manully login in to ur DB and check through
    select name from v$datafile;
  • 5. Re: ASM instance Verification
    User477708-OC Journeyer
    Currently Being Moderated
    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
    vikrams Newbie
    Currently Being Moderated
    Log into the ASM instance and query the view v$ASM_CLIENT
  • 7. Re: ASM instance Verification
    nnarimanov Newbie
    Currently Being Moderated
    It's true for 11g
    ASMCMD> lsct -g

Legend

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