Oracle11gR2 找出ASM diskgroup中的ASM spfile

loinooo

[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'  

marsdreamyao

原谅我心中疯狂的执着