欢迎 on it road

解决方案

最初包含 spfile 的磁盘组已损坏。
唯一的选择是在新磁盘组中创建 spfile,然后使用 -force 选项删除旧磁盘组。
或者删除损坏的磁盘组并重新创建它。

无法为 Oracle ASM 实例创建 spfile

问题

尝试在 asm 实例中创建 spfile 时,遇到以下错误:

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], [], [], [], [], [], [], []

ASM01 磁盘组显示以下磁盘:

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

ASM 实例的alert.log文件:

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 <ORACLE_BASE>/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: <ORACLE_BASE>/diag/asm/+asm/+ASM/incident/incdir_131337/+ASM_ora_52943_i131337.trc
Use ADRCI or Support Workbench to package the incident.
日期:2020-09-17 00:11:50 来源:oir作者:oir