Database Administration (MOSC)

MOSC Banner

(RAC) datafile -> physical disk link under ASM

edited Dec 22, 2011 8:51PM in Database Administration (MOSC) 2 commentsAnswered
Hello,

i would like to ask for help with following question. It is possible to find a direct link, between  datafile - physical disk/mountpoint under ASM ?
If yes, how.

In example, in following select:

NAME                      GROUP_NUMBER DISK_NUMBER MOUNT_STATUS          STATE                    PATH
------------------------- ------------ ----------- --------------------- ------------------------ ------------------------------
ASM_DATA1_000                        1           0 OPENED                NORMAL                   /dev/asm_disk1
ASM_
DATA1_002                        1           1 OPENED                NORMAL                   /dev/asm_disk2
ASM_
DATA2_001                        2           2 OPENED                NORMAL                   /dev/asm_disk3
ASM_
DATA2_002                        2           3 OPENED                NORMAL                   /dev/asm_disk4

One would be able to link datafile and specific group, but as the file_name under v$datafile specification doesn't reflect the complete name shown in v$asm_disk one can't tell which exact disk/mountpoint is the datafile stored in, only group. And say we have hundreds of disk for one group. Then again, it is possible to deduce the link, if yes, how. Any feedback would be really appreciated.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center