This discussion is archived
4 Replies Latest reply: Dec 21, 2012 4:43 AM by Robin RSS

ASM and database doubt

Robin Newbie
Currently Being Moderated
Hi,

I've some doubt in ASM and database. We usually can identify the database whether it is in ASM or not in the datafile or control file location. Is there any other way to identify whether db is running in ASM?

Your help is much appreciated.

Thanks,
Robin
  • 1. Re: ASM and database doubt
    EBSDBA Expert
    Currently Being Moderated
    Hi,

    Look in the parameter file...

    Thanks
  • 2. Re: ASM and database doubt
    Fran Guru
    Currently Being Moderated
    check any of asm views like:
    V$ASM_ALIAS
    V$ASM_CLIENT
    V$ASM_DISK     
    V$ASM_DISKGROUP     
    V$ASM_FILE


    if you haven't data, No ASM .
  • 3. Re: ASM and database doubt
    CKPT Guru
    Currently Being Moderated
    Robin wrote:
    Hi,

    I've some doubt in ASM and database. We usually can identify the database whether it is in ASM or not in the datafile or control file location. Is there any other way to identify whether db is running in ASM?

    Your help is much appreciated.

    Thanks,
    Robin
    You can see view SQL> select name,state from v$asm_diskgroup; from RDBMS instance
    If you can able to see the disk groups from the RDBMS instance, If the state is CONNECTED for the disk groups then the RDBMS instance is using ASM if not the status can be "MOUNT" or BROKEN, OR DISMOUNTED or UKNNOWN.

    >
    Robin      
         Newbie
         
    Handle:      Robin
    Status Level:      Newbie (5)
    Registered:      Oct 30, 2007
    Total Posts:      196
    Total Questions:      91 (73 unresolved)
    >

    Please try to close your old threads and also if any further are answered for any question close it or else other users will again review whole thread. Instead of that they can spend time in other threads. Hope you understood.

    Edited by: CKPT on Dec 21, 2012 5:48 PM
  • 4. Re: ASM and database doubt
    Robin Newbie
    Currently Being Moderated
    Thanks a lot everyone. CKPT answer was very useful. I am closing the thread now as answered.

Legend

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