文档介绍：Zhong Weicheng Study Notes
Insist on his own ideal, and to attain it.
Oracle11gR2 找出ASM diskgroup中的ASM spfile
分类: Oracle Oracle RAC Oracle ASM 2013-11-29 14:05 197人阅读评论(0) 收藏举报
OracleOracle RACOracle ASM
[******@vzwc1 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is []
[******@vzwc1 ~]$
[******@vzwc1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 400bdba7f2e64f8fbf23f6806f25e4c6 (/dev/asm-diskg) [SYSDG]
2. ONLINE 76ff5698d65c4f0dbf7693abd7c33a4b (/dev/asm-diskh) [SYSDG]
3. ONLINE 6410be3052a94ffdbfa2805c73cef4ea (/dev/asm-diski) [SYSDG]
4. ONLINE 76aedd7a81c74f75bf09bf5020bf340a (/dev/asm-diskj) [SYSDG]
5. ONLINE 6968dea5a6be4f17bf0a6caa8a23d534 (/dev/asm-diskk) [SYSDG]
Located 5 voting disk(s).
找出ASM mirror extent
SQL> select GROUP_KFFXP, DISK_KFFXP, AU_KFFXP
2 from x$kffxp
3 where number_kffxp =
4 (select file_number
5 from v$asm_alias
6 where name = '');
GROUP_KFFXP DISK_KFFXP AU_KFFXP
----------- ---------- ----------
1 0 34
1 3 35
1 4 36
SQL>
SQL> select GROUP_KFDAT, NUMBER_KFDAT, AUNUM_KFDAT
2 from x$kfdat
3 where fnum_kfdat = (select file_number
4 from v$asm_alias
5 where name = '');
GROUP_KFDAT NUMBER_KFDAT AUNUM_KFDAT
----------- --------