分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
time:2011/12/01
环境:
os:CentOS release 5.5
db: 11.2.0.2.0 - 64bit Production
physical dataguard
现象:只是报ora-00600: 内部错误代码, 参数: [4415];数据库还是可以正常提供服务
诊断:
这套oracle11g的DG已经运行一段时间了,在调整了些小问题后,目前运行还是比较稳定,今天
在primary库收到报警,在alertlog里的错误信息如下:
Wed Nov 30 17:58:28 2011
Archived Log entry 1547 added for thread 1 sequence 7842 ID 0xa47b04d0 dest 1:
Wed Nov 30 18:21:33 2011
Media Recovery Waiting for thread 1 sequence 7844
Wed Nov 30 18:21:34 2011
RFS[5]: Selected log 7 for thread 1 sequence 7844 dbid -1535431216 branch 760042576
Recovery of Online Redo Log: Thread 1 Group 7 Seq 7844 Reading mem 0
Mem# 0: /oracle/oradata/skatedb/sdbyredo07.log
Wed Nov 30 18:21:41 2011
Archived Log entry 1548 added for thread 1 sequence 7843 ID 0xa47b04d0 dest 1:
Wed Nov 30 18:28:20 2011
Errors in file /oracle/app/diag/rdbms/skate03/skatedb/trace/skatedb_ora_31048.trc (incident=56617):
ora-00600: 内部错误代码, 参数: [4415], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/diag/rdbms/skate03/skatedb/incident/incdir_56617/skatedb_ora_31048_i56617.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
System State dumped to trace file /oracle/app/diag/rdbms/skate03/skatedb/incident/incdir_56617/skatedb_ora_31048_i56617.trc
Wed Nov 30 18:29:19 2011
Dumping diagnostic data in directory=[cdmp_20111130182919], requested by (instance=1, osid=31048), summary=[incident=56617].
Wed Nov 30 18:29:25 2011
Errors in file /oracle/app/diag/rdbms/skate03/skatedb/trace/skatedb_ora_31048.trc (incident=56618):
ora-00603: ORACLE 服务器会话因致命错误而终止
ora-00600: 内部错误代码, 参数: [4415], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/diag/rdbms/skate03/skatedb/incident/incdir_56618/skatedb_ora_31048_i56618.trc
Dumping diagnostic data in directory=[cdmp_20111130182926], requested by (instance=1, osid=31048), summary=[incident=56618].
opiodr aborting process unknown ospid (31048) as a result of ora-603
Wed Nov 30 18:29:29 2011
Sweep [inc][56618]: completed
Sweep [inc][56617]: completed
Sweep [inc2][56618]: completed
Sweep [inc2][56617]: completed
Wed Nov 30 18:44:01 2011
RFS[5