千家信息网

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

发表于:2024-12-01 作者:千家信息网编辑
千家信息网最后更新 2024年12月01日,环境:RHEL 5.8发现数据库startup启动时报ORA-03113:通信通道的文件结尾进程 ID :6988回话 ID:191 序列号:3[oracle@localhost ~]$ cd $OR
千家信息网最后更新 2024年12月01日oracle启动报错:ORA-03113:通信通道的文件结尾

环境:RHEL 5.8

发现数据库startup启动时报

ORA-03113:通信通道的文件结尾

进程 ID :6988

回话 ID:191 序列号:3

[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

[oracle@localhost trace]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on 星期四 2月 25 13:49:56 2016Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to an idle instance.SQL> startup mount;ORACLE instance started.Total System Global Area 2471931904 bytesFixed Size    2230872 bytesVariable Size 1560282536 bytesDatabase Buffers  889192448 bytesRedo Buffers   20226048 bytesDatabase 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|0SQL>SQL> alter database clear unarchived logfile group 1; //执行此行时可能出错,如有报错直接把1修改成2或3之后再执行1SQL> 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 bytesFixed Size    2230872 bytesVariable Size 1560282536 bytesDatabase Buffers  889192448 bytesRedo Buffers   20226048 bytesDatabase mounted.Database opened.SQL> select status from v$instance;STATUS------------OPENSQL> exit


0