The Problem
While trying to create spfile in asm instance, the following errors are encountered:
SQL> create spfile='+[DGNAME]' from pfile='[PATH]/grid/dbs/init+ASM.ora'; create spfile='+[DGNAME]' from pfile='[PATH]/dbs/init+ASM.ora' * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver], [0x09D00B1D0], [4], [0x7F01BA873800], [1024], [], [], [], [], [], [], []
The following disks are showing for ASM01 diskgroup:
Sql> select path,os_mb,header_status from v$asm_disk where group_number=1 PATH OS_MB HEADER_STATU -------------------------------------------------- ---------- ------------ 0 UNKNOWN [PATH]/lo10Glun002p1 10236 MEMBER
From the ASM instance alert log file:
Fri Jan 08 23:08:28 2016 NOTE: Using default ASM root directory ASM NOTE: updated gpnp profile ASM diskstring: [PATH]/lo*p1 WARNING: media corrupt block seen on file '+[DGNAME]/asm/asmparameterfile/registry.253.900630509' blockno=4 Reread resulted in same corrupt block on file '+[DGNAME]/asm/asmparameterfile/registry.253.900630509' blockno=4 from mirror side 1 (ASM01_0000) logical extent number 0 Reread resulted in same corrupt block on file '+[DGNAME]/asm/asmparameterfile/registry.253.900630509' blockno=4 from mirror side 1 (ASM01_0000) logical extent number 0 Errors in file/diag/asm/+asm/+ASM/trace/+ASM_ora_52943.trc (incident=131337): ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver], [0x09D00B1D0], [4], [0x7F327BD77200], [1024], [], [], [], [], [], [], [] Incident details in: /diag/asm/+asm/+ASM/incident/incdir_131337/+ASM_ora_52943_i131337.trc Use ADRCI or Support Workbench to package the incident.
The Solution
The diskgroup that originally contained the spfile has become corrupted. The only options are – create the spfile in a new diskgroup then drop the old diskgroup using the -force option. Or drop the corrupted diskgroup and recreate it.