欢迎 on
it
road
解决方案
最初包含 spfile 的磁盘组已损坏。
唯一的选择是在新磁盘组中创建 spfile,然后使用 -force 选项删除旧磁盘组。
或者删除损坏的磁盘组并重新创建它。
问题
尝试在 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