get spfile content from disk when asm failure

SQL*Plus: Release 11.2.0.2.0 Production on Wed May 18 15:59:27 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select GROUP_NUMBER,FILE_NUMBER,BYTES from v$asm_file where type='PARAMETERFILE';

GROUP_NUMBER FILE_NUMBER      BYTES
------------ ----------- ----------
           2         267       3584

SQL> select DISK_KFFXP,AU_KFFXP,PXN_KFFXP,XNUM_KFFXP,LXN_KFFXP from x$kffxp where GROUP_KFFXP=2 and NUMBER_KFFXP=267;

DISK_KFFXP   AU_KFFXP  PXN_KFFXP XNUM_KFFXP  LXN_KFFXP
---------- ---------- ---------- ---------- ----------
         0       1958          0          0          0

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

FAILGROUP                      DISK_NUMBER                     PATH
----------------------------------------------------------------------------------------
DATA_0000                                0                   /dev/sdb1

SQL> select ALLOCATION_UNIT_SIZE    from v$asm_diskgroup where GROUP_NUMBER =2;

ALLOCATION_UNIT_SIZE
--------------------
             1048576

SQL> 
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
->dd if=/dev/sdb1 bs=1M count=1 skip=1958|strings|head -20
1+0 records in
1+0 records out
1048576 bytes (1.0 MB) copied, 0.021288 seconds, 49.3 MB/s
henry1.__db_cache_size=654311424
henry2.__db_cache_size=469762048
henry1.__java_pool_size=16777216
henry2.__java_pool_size=16777216
henry1.__large_pool_size=16777216
henry2.__large_pool_size=16777216
henry1.__oracle_base='/opt/app/oracle'#ORACLE_BASE set from environment
henry2.__oracle_base='/opt/app/oracle'#ORACLE_BASE set from environment
henry2.__pga_aggregate_target=570425344
henry1.__pga_aggregate_target=570425344
henry2.__sga_target=1090519040
henry1.__sga_target=1090519040
nry1.__shared_io_pool_size=0
henry2.__shared_io_pool_size=0
henry1.__shared_pool_size=385875968
henry2.__shared_pool_size=570425344
henry1.__streams_pool_size=0
henry2.__streams_pool_size=0
*.audit_file_dest='/opt/app/oracle/admin/henry/adump'
*.audit_trail='db'
->

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/46907/viewspace-696644/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/46907/viewspace-696644/