5 Replies Latest reply: Sep 19, 2012 12:25 AM by 932706 RSS

    How can i know real directory path for ASM Disks

    932706
      Hello everybody, i'm a little novice using ASM definitions and i need to know where all data is stored in the Operating System storage devices, but i don't know where that exactly is.

      Searching some queries i found:

      select GROUP_NUMBER, DISK_NUMBER, MODE_STATUS, STATE, NAME, PATH from v$asm_disk

      And i realized that it's shown in PATH column, but in examples it show normal SO linux path like: '/asm1/storage/datafile1_asm.20001.41010'

      Running the same query in ASM instance the PATH column show something like: ' ORCL:PROD1_DATA30'

      So, what does that mean? i cannot see any path or similar. i thought it was a directory from database but searching in DB instance it doesn't exists.

      Any idea.

      Thanks.