Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

6

主题
1#
发表于 2013-4-18 10:03:14 | 查看: 5117| 回复: 3
有一台小机,AIX 5.3,11.2.0.3,非RAC,每天早上有crontab做定时的expdb备份,今天发现expdb途中报ORA-00600,实例被PMON终止。

11.2.0.3的库在做expdp备份的时候出DW00进程异常,然后PMON进程终止,然后实例崩溃。

日志摘要如下:
Errors in file /u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_dw00_2265258.trc  (incident=30042)
ORA-00600: internal error code, arguments: [17114], [0x700000109CDD668], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/oracle/diag/rdbms/oradb/oradb/incident/incdir_30042/oradb_dw00_2265258_i30042.trc
PMON (ospid: 1523812): terminating the instance due to error 472
System state dump requested by (instance=1, osid=1523812 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_diag_1609800.trc

这里是全部的trc等日志信息。

ora-00600.zip (8.71 MB, 下载次数: 618)
2#
发表于 2013-4-18 10:06:05
Thu Apr 18 04:05:51 2013
Archived Log entry 25737 added for thread 1 sequence 25824 ID 0xffffffff97dac173 dest 1:
Thu Apr 18 04:06:41 2013
DM00 started with pid=154, OS id=1994920, job SYSTEM.SYS_EXPORT_SCHEMA_01
Thu Apr 18 04:06:44 2013
DW00 started with pid=155, OS id=3412046, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_01
Thu Apr 18 04:07:31 2013
DM00 started with pid=154, OS id=3457136, job SYSTEM.SYS_EXPORT_SCHEMA_01
Thu Apr 18 04:07:33 2013
DW00 started with pid=155, OS id=2265258, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_01
Thu Apr 18 04:07:37 2013
DW01 started with pid=156, OS id=1769518, wid=2, job SYSTEM.SYS_EXPORT_SCHEMA_01
Thu Apr 18 04:07:55 2013
Errors in file /database/u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_dw00_2265258.trc  (incident=30041):
ORA-00600: internal error code, arguments: [17114], [0x700000109CDD668], [], [], [], [], [], [], [], [], [], []
Incident details in: /database/u01/oracle/diag/rdbms/oradb/oradb/incident/incdir_30041/oradb_dw00_2265258_i30041.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Apr 18 04:08:29 2013
Dumping diagnostic data in directory=[cdmp_20130418040829], requested by (instance=1, osid=2265258 (DW00)), summary=[incident=30041].
Thu Apr 18 04:08:29 2013
Errors in file /database/u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_dw00_2265258.trc  (incident=30042):
ORA-00600: internal error code, arguments: [17114], [0x700000109CDD668], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17114], [0x700000109CDD668], [], [], [], [], [], [], [], [], [], []
Incident details in: /database/u01/oracle/diag/rdbms/oradb/oradb/incident/incdir_30042/oradb_dw00_2265258_i30042.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Apr 18 04:08:30 2013
Sweep [inc][30041]: completed
Sweep [inc][30042]: completed
Sweep [inc2][30041]: completed
Thu Apr 18 04:08:50 2013
Sweep [inc2][30042]: completed
Thu Apr 18 04:08:50 2013
Dumping diagnostic data in directory=[cdmp_20130418040850], requested by (instance=1, osid=2265258 (DW00)), summary=[incident=30042].
Thu Apr 18 04:09:17 2013
ERROR: Unable to normalize symbol name for the following short stack (at offset 453):
dbgexProcessError()+180<-dbgeExecuteForError()+72<-dbgePostErrorKGE()+2048<-dbkePostKGE_kgsf()+68<-kgeade()+364<-kgeriv_int()+116<-kgeriv()+36<-kgeric1()+60<-kgherror()+324<-kgh
frmrg()+1884<-kghfre()+368<-kksParentHandleFreeCbk()+248<-kgllccl()+636<-kglMutexRecovery()+472<-kgxCleanup()+532<-kglMutexCleanupAll()+496<-kglMutexCleanup()+20<-kksCleanSessio
nState()+228<-ksudlp()+1972<-kssxdl()+472<-kssdel()+724<-ksuxdl()+456<-ksuxda_del_proc()+188<-IPRA.$ksucln_dpc_cleanup()+272<-IPRA.$ksucln_dpc_dfs()+268<-ksucln_dpc_main()+892<-
ksucln_dpc()+36<-ksucln()+1340<-ksbrdp()+2044<-opirip()+1624<-opidrv()+608<-sou2o()+136<-opimai_real()+188<-ssthrdmain()+268<-main()+204<-__start()+152
Errors in file /database/u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_pmon_1523812.trc  (incident=28817):
ORA-00600: internal error code, arguments: [17114], [0x700000109CDD668], [], [], [], [], [], [], [], [], [], []
Incident details in: /database/u01/oracle/diag/rdbms/oradb/oradb/incident/incdir_28817/oradb_pmon_1523812_i28817.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Apr 18 04:09:34 2013
Dumping diagnostic data in directory=[cdmp_20130418040934], requested by (instance=1, osid=1523812 (PMON)), summary=[incident=28817].
Thu Apr 18 04:09:36 2013
Errors in file /database/u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_pmon_1523812.trc:
ORA-00600: internal error code, arguments: [17114], [0x700000109CDD668], [], [], [], [], [], [], [], [], [], []
PMON (ospid: 1523812): terminating the instance due to error 472
System state dump requested by (instance=1, osid=1523812 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /database/u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_diag_1609800.trc
Instance terminated by PMON, pid = 1523812

回复 只看该作者 道具 举报

3#
发表于 2013-4-18 10:06:29
日志补充如上。

回复 只看该作者 道具 举报

4#
发表于 2013-4-18 13:57:50
请提供expdp的日志
请提供执行的expdp的完整语句(正常情况下日志会有,请自行确认,否则在此贴出)

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 11:44 , Processed in 0.050407 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569