Email: service@parnassusdata.com 7 x 24 online support!
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命令几乎被立即终止。