ORA-00600 [16703], [1403], [20]一例

如果自己搞不定可以找诗檀软件专业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

*

沪ICP备14014813号

沪公网安备 31010802001379号