1. 问题描述

数据库进行不完全恢复，在使用 recover database until scn xxxx; 后进行open resetlogs 时报错。 http://www.cndba.cn/dave/article/2954

Dump file /u01/app/oracle/diag/rdbms/primary/hyora/incident/incdir_57757/hyora_ora_1271_i57757.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0.4.0/db_1
System name:    Linux
Node name:    xg156
Release:    2.6.32-431.el6.x86_64
Version:    #1 SMP Fri Nov 22 03:15:09 UTC 2013
Machine:    x86_64
VM name:    VMWare Version: 6
Instance name: hyora
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 1271, image: oracle@xg156 (TNS V1-V3)


*** 2018-08-17 14:43:00.370
*** SESSION ID:(351.5) 2018-08-17 14:43:00.370
*** CLIENT ID:() 2018-08-17 14:43:00.370
*** SERVICE NAME:() 2018-08-17 14:43:00.370
*** MODULE NAME:(sqlplus@xg156 (TNS V1-V3)) 2018-08-17 14:43:00.370
*** ACTION NAME:() 2018-08-17 14:43:00.370

Dump continued from file: /u01/app/oracle/diag/rdbms/primary/hyora/trace/hyora_ora_1271.trc
ORA-00600: internal error code, arguments: [krsi_al_hdr_update.15], [4294967295], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 57757 (ORA 600 [krsi_al_hdr_update.15]) ========

*** 2018-08-17 14:43:00.370
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=d5hp3vvqww874) -----
alter database open RESETLOGS

----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
skdstdst()+41        call     kgdsdst()            000000000 ? 000000000 ?
                                                   7FFFC2BB2990 ? 7FFFC2BB2A68 ?
                                                   7FFFC2BB7510 ? 000000002 ?
ksedst1()+103        call     skdstdst()           000000000 ? 000000000 ?
                                                   7FFFC2BB2990 ? 7FFFC2BB2A68 ?
                                                   7FFFC2BB7510 ? 000000002 ?

2. 解决方法

在操作系统级别对current online redologs进行重命名, 然后就可以正常打开了http://www.cndba.cn/dave/article/2954

$ mv /u01/data/data_domains/dod1/redo01.log /u01/data/data_domains/dod1/redo01.OLD
$ mv /u01/data/data_domains/dod1/redo01b.log /u01/data/data_domains/dod1/redo01b.OLD

SQL>alter database open resetlogs;
Database altered

版权声明：本文为博主原创文章，未经博主允许不得转载。