作者 阿九【转载时请务必以超链接形式标明文章原始出处和作者信息】
今天处理一个ORA-607/ORA-600 [4194] 的异常,数据库能mount,也能open,但是在open的时候报错“ORA-03113: end-of-file on communication channel”,奇怪的是,查看数据库状态还是“READ WRITE” ,不过一会数据库自动终止。后来发现,数据库能启动到open状态是因为在参数文件中添加了隐含参数_allow_resetlogs_corruption=ture(我去处理的时候就已经加了)
$ sqlplus /nolog SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 21 17:52:43 2013 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. SQL> conn /as sysdba Connected to an idle instance. SQL> startup mount; ORACLE instance started. Total System Global Area 6442450944 bytes Fixed Size 2065752 bytes Variable Size 1979714216 bytes Database Buffers 4445962240 bytes Redo Buffers 14708736 bytes Database mounted. SQL> alter database open; ORA-03113: end-of-file on communication channel SQL> select open_mode from v$database; OPEN_MODE ---------- READ WRITE SQL> |