(RAC) datafile -> physical disk link under ASM
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.
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.
0