Oracle shutdown时报告ORA-604 ORA-448

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

ora-00604

oerr ora 00604
00604, 00000, "error occurred at recursive SQL level %s"
// *Cause: An error occurred while processing a recursive SQL statement
// (a statement applying to internal dictionary tables).
// *Action: If the situation described in the next error on the stack
// can be corrected, do so; otherwise contact Oracle Support.

ora-00448

 oerr ora 448
00448, 00000, "normal completion of background process"
// *Cause: One of the background processes completed normally (i.e. exited).
// The background process thinks that somebody asked it to exit.
// *Action: Warm start the system.

适用于：

Oracle Database – Enterprise Edition – 版本11.1.0.7 到11.2.0.1 [Release 11.1 to 11.2]
本文信息适用于任何平台。
*** 20-OCT-2014 检查相关性***

症状
Trace File 显示：
~~~~~~~~~~~~~~

*** 2010-04-09 22:43:34.849
Reading CompilerOptions…

*** 2010-04-09 22:43:42.297
joxjitexe0 caught: 604; Aborting
joxjitexe1 caught: 604;
ORA-00604: error occurred at recursive SQL level 1
ORA-00448: normal completion of background process

Alert log 显示：
~~~~~~~~~~~~~~

Fri Apr 09 22:43:03 2010
Completed: ALTER DATABASE OPEN
Fri Apr 09 22:43:37 2010
Stopping background process SMCO
Stopping background process FBDA
Shutting down instance: further logons disabled
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
Fri Apr 09 22:43:42 2010
Errors in file /pvebai/oracle/product/111/admin/PVEBAI_auohsveba05/diag/rdbms/pvebai/PVEBAI/trace/PVEBAI_m000_559.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00448: normal completion of background process
Shutting down instance (immediate)

原因
错误是由于当shutdown命令被发出时，MMON 进程刚启动就被打断。
解决方案

当数据库被打开后shutdown immediate 被立即发出时，执行一个startup restrict。
 
 这避免了这种类型的问题，其中被启动的secondary进程或作业由于shutdown命令几乎被立即终止。