oracle启动报错：ORA-03113：通信通道的文件结尾

3422

环境：RHEL 5.8
发现数据库startup启动时报
ORA-03113：通信通道的文件结尾
进程 ID ：6988
回话 ID：191 序列号：3

1 2 3 4

[oracle@localhost ~]$ cd $ORACLE_BASE [oracle@localhost oracle]$ cd diag/rdbms/oracle/oracle/trace/ [oracle@localhost trace]$ ll -rt |tail [oracle@localhost trace]$ vim oracle_ora_13430.trc

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

[oracle@localhost trace]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on 星期四 2月 25 13:49:56 2016 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup mount; ORACLE instance started. Total System Global Area 2471931904 bytes Fixed Size    2230872 bytes Variable Size 1560282536 bytes Database Buffers  889192448 bytes Redo Buffers   20226048 bytes Database mounted. SQL> select NAME||'|'||SPACE_LIMIT||'|'||SPACE_USED||'|'||SPACE_RECLAIMABLE||'|'||NUMBER_OF_FILES from v$recovery_file_dest; NAME||'|'||SPACE_LIMIT||'|'||SPACE_USED||'|'||SPACE_RECLAIMABLE||'|'||NUMBER_OF_ -------------------------------------------------------------------------------- /u01/app/oracle/fast_recovery_area|6180|0|0|0 SQL> SQL> alter database clear unarchived logfile group 1; //执行此行时可能出错，如有报错直接把1修改成2或3之后再执行1 SQL> alter database clear unarchived logfile group 2; SQL> alter database clear unarchived logfile group 1; Database altered. SQL> commit; Commit complete. SQL> shutdown immediate; SQL> startup; ORACLE instance started. Total System Global Area 2471931904 bytes Fixed Size    2230872 bytes Variable Size 1560282536 bytes Database Buffers  889192448 bytes Redo Buffers   20226048 bytes Database mounted. Database opened. SQL> select status from v$instance; STATUS ------------ OPEN SQL> exit