Oracle11gR2 找出ASM diskgroup中的ASM spfile

[grid@vzwc1 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.4.0]
[grid@vzwc1 ~]$ 
[grid@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 = 'REGISTRY.253.826491951');

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 = 'REGISTRY.253.826491951');

GROUP_KFDAT NUMBER_KFDAT AUNUM_KFDAT
----------- ------------ -----------
          1            0          34
          1            3          35
          1            4          36

找出对应的disk

SQL> select path,DISK_NUMBER from v$asm_disk where GROUP_NUMBER=1 and disk_number in (0,3,4);

PATH                 DISK_NUMBER
-------------------- -----------
/dev/asm-diskf                 4
/dev/asm-diske                 3
/dev/asm-diskb                 0

创建pfile，查看内容

SQL> create pfile='/tmp/asm.ora' from spfile;

File created.

SQL> !cat /tmp/asm.ora
+ASM1.asm_diskgroups='SYSDG','DATADG','FRADG','OGGDG'#Manual Mount
+ASM2.asm_diskgroups='DATADG','FRADG','SYSDG','OGGDG'#Manual Mount
*.asm_diskstring='/dev/asm-*'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

SQL> 

dd读取AUNUM_KFDAT

[grid@vzwc1 ~]$ dd if=/dev/asm-diskb of=/tmp/spfile1.ora skip=34 bs=1024k count=1
1+0 records in
1+0 records out
1048576 bytes (1.0 MB) copied, 0.0491284 seconds, 21.3 MB/s
[grid@vzwc1 ~]$ 
[grid@vzwc1 ~]$ strings /tmp/spfile1.ora 
+ASM1.asm_diskgroups='SYSDG','DATADG','FRADG','OGGDG'#Manual Mount
+ASM2.asm_diskgroups='DATADG','FRADG','SYSDG','OGGDG'#Manual Mount
*.asm_diskstring='/dev/asm-*'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

[grid@vzwc1 ~]$ dd if=/dev/asm-diske of=/tmp/spfile2.ora skip=35 bs=1024k count=1
1+0 records in
1+0 records out
1048576 bytes (1.0 MB) copied, 0.0244123 seconds, 43.0 MB/s
[grid@vzwc1 ~]$ 
[grid@vzwc1 ~]$ strings /tmp/spfile2.ora
+ASM1.asm_diskgroups='SYSDG','DATADG','FRADG','OGGDG'#Manual Mount
+ASM2.asm_diskgroups='DATADG','FRADG','SYSDG','OGGDG'#Manual Mount
*.asm_diskstring='/dev/asm-*'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

[grid@vzwc1 ~]$ dd if=/dev/asm-diskf of=/tmp/spfile3.ora skip=36 bs=1024k count=1
1+0 records in
1+0 records out
1048576 bytes (1.0 MB) copied, 0.0141957 seconds, 73.9 MB/s
[grid@vzwc1 ~]$ strings /tmp/spfile3.ora 
+ASM1.asm_diskgroups='SYSDG','DATADG','FRADG','OGGDG'#Manual Mount
+ASM2.asm_diskgroups='DATADG','FRADG','SYSDG','OGGDG'#Manual Mount
*.asm_diskstring='/dev/asm-*'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'