如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com
某用户核心数据库出现ORA-00600 [16703], [1403], [20] 错误导致数据库无法OPEN，其详细报错如下：
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 2 21:05:48 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter database open; alter database open * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [] Message 3144 not found; product=RDBMS; facility=ORA Message 3142 not found; product=RDBMS; facility=ORA
该ORA-00600 [16703]内部错误常见于 当数据库核心字典对象 例如OBJ$ TAB$等核心数据字典表出现讹误时触发； 对于该类该ORA-00600 [16703]错误 可以首先了解其trace文件：
SMON: enabling cache recovery
Errors in file /s01/diag/rdbms/test10/TEST10/trace/TEST10_ora_4317.trc (incident=8553):
ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], []
Incident details in: /s01/diag/rdbms/test10/TEST10/incident/incdir_8553/TEST10_ora_4317_i8553.trc
Errors in file /s01/diag/rdbms/test10/TEST10/trace/TEST10_ora_4317.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], []
Errors in file /s01/diag/rdbms/test10/TEST10/trace/TEST10_ora_4317.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], []
Error 704 happened during db open, shutting down database
USER (ospid: 4317): terminating the instance due to error 704
Instance terminated by USER, pid = 4317
ORA-1092 signalled during: alter database open...
opiodr aborting process unknown ospid (4317) as a result of ORA-1092
Thu May 02 21:05:52 2013
ORA-1092 : opitsk aborting process
/s01/diag/rdbms/test10/TEST10/incident/incdir_8553/TEST10_ora_4317_i8553.trc
*** 2013-05-02 21:05:52.076
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=a01hp0psv0rrh) -----
alter database open
----- Call Stack Trace -----
gesiv()+110 call kgeriv() 00A99D540 ? 7F6AF2FBF5B0 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
ksesic2()+194 call kgesiv() 00A99D540 ? 7F6AF2FBF5B0 ?
00000413F ? 000000002 ?
7FFF0E034070 ? 000000000 ?
kqlbpob()+1383 call ksesic2() 00A99D540 ? 000000000 ?
00000057B ? 000000000 ?
000000014 ? 000008000 ?
kqrlfc()+678 call kqlbpob() 000000033 ? 000000000 ?
00000057B ? 000000000 ?
000000014 ? 000008000 ?
kqlbplc()+175 call kqrlfc() 000000033 ? 7FFF0E034480 ?
00000057B ? 000000000 ?
000000014 ? 000008000 ?
kqlblfc()+275 call kqlbplc() 000000000 ? 7FFF0E034480 ?
00000057B ? 000000000 ?
000000014 ? 000008000 ?
adbdrv()+40310 call kqlblfc() 000000000 ? 7FFF0E0399C0 ?
00000057B ? 000000000 ?
000000014 ? 000008000 ?
opiexe()+15552 call adbdrv() 000000000 ? 0A2B94B98 ?
*****************************************************
----- Session Open Cursors -----
----------------------------------------
Cursor#2(0x7f6af2a719a8) state=BOUND curiob=0x7f6af2a815b0
curflg=f fl2=200000 par=0x7f6af2a71918 ses=0xaa848988
----- Dump Cursor sql_id=bqbdby3c400p7 xsc=0x7f6af2a815b0 cur=0x7f6af2a719a8 -----
LibraryHandle: Address=a98ba1c0 Hash=d84002a7 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
ObjectName: Name=select rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,nvl(degree,1), nvl(instances,1) from tab$ where obj# = :1
若看到—– Session Open Cursors —–中有 select rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,nvl(degree,1), nvl(instances,1) from tab$ where obj# = :1 此语句则一般说明是TAB$ 基表受损， 需要修复该表； 但如果是该表大面积损坏则没有修复的可能。
可以考虑使用PRM-DUL类工具抽取该损坏数据库中的数据并重建数据库。
Comment