软件开发Oracle故障诊断

各位大佬请问下 数据库启动报这个错怎么处理ORA-03113: end-of-file on communication channel?

各位大佬请问下SQL> startupORACLE instance started.Total System Global Area 2.9262E+10 bytesFixed Size 2242504 bytesVariable Size 3556771896 bytesDatabase Buffers 2.5636E+10 bytesRedo Buffers 678502...显示全部

各位大佬请问下
SQL> startup
ORACLE instance started.

Total System Global Area 2.9262E+10 bytes
Fixed Size 2242504 bytes
Variable Size 3556771896 bytes
Database Buffers 2.5636E+10 bytes
Redo Buffers 67850240 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 7631
Session ID: 937 Serial number: 3

error 472 detected in background process
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
kjzduptcctx: Notifying DIAG for crash event
----- Abridged Call Stack Trace -----
ksedsts()+461<-kjzdssdmp()+267<-kjzduptcctx()+232<-kjzdicrshnfy()+53<-ksuitm()+1332<-ksbrdp()+3344<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+266<-ssthrdmain()+252<-main()+201<-__libc_start_main()+253<-_start()+36
----- End of Abridged Call Stack Trace -----

* 2017-09-05 18:48:36.249
PMON (ospid: 7576): terminating the instance due to error 472
ksuitm: waiting up to [5] seconds before killing DIAG(7586)

数据库启动报这个错怎么处理?

alert里边看到是redo恢复的时候出了错。。

Recovery of Online Redo Log: Thread 1 Group 5 Seq 47 Reading mem 0
Mem# 0: /data1/oracle/app/oradata/njhb/redo05.log
Block recovery completed at rba 47.204.16, scn 0.33145327
Block recovery from logseq 47, block 202 to scn 33145446
Recovery of Online Redo Log: Thread 1 Group 5 Seq 47 Reading mem 0
Mem# 0: /data1/oracle/app/oradata/njhb/redo05.log
Block recovery completed at rba 47.290.16, scn 0.33145447
Block recovery from logseq 47, block 202 to scn 33145324
Recovery of Online Redo Log: Thread 1 Group 5 Seq 47 Reading mem 0
Mem# 0: /data1/oracle/app/oradata/njhb/redo05.log
Block recovery completed at rba 47.204.16, scn 0.33145327
Block recovery from logseq 47, block 202 to scn 33145448
Recovery of Online Redo Log: Thread 1 Group 5 Seq 47 Reading mem 0
Mem# 0: /data1/oracle/app/oradata/njhb/redo05.log
Block recovery completed at rba 47.292.16, scn 0.33145449
Tue Sep 05 18:44:02 2017
Block recovery from logseq 47, block 202 to scn 33145324
Recovery of Online Redo Log: Thread 1 Group 5 Seq 47 Reading mem 0
Mem# 0: /data1/oracle/app/oradata/njhb/redo05.log
Block recovery completed at rba 47.204.16, scn 0.33145327
Block recovery from logseq 47, block 202 to scn 33145450
Recovery of Online Redo Log: Thread 1 Group 5 Seq 47 Reading mem 0
Mem# 0: /data1/oracle/app/oradata/njhb/redo05.log
Block recovery completed at rba 47.298.16, scn 0.33145451
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 36 out of maximum 100 non-fatal internal errors.

收起
参与17

查看其它 2 个回答轻松熊的回答

轻松熊轻松熊数据库管理员某科技公司
[此回答已删除]
浏览1435

回答者

轻松熊
数据库管理员某科技公司
擅长领域: 服务器AIXUnix

轻松熊 最近回答过的问题

回答状态

  • 发布时间:2017-09-05
  • 关注会员:2 人
  • 回答浏览:1435
  • X社区推广