ORA-03113: end-of-file on communication channel

最新推荐文章于 2021-04-07 14:31:10 发布

转载最新推荐文章于 2021-04-07 14:31:10 发布 · 104 阅读

本文记录了在测试环境中删除Redo日志后导致数据库无法正常启动的问题，并提供了详细的解决步骤，包括清除未归档的日志文件组及重启数据库。

问题描述：

今天，在网上看到一篇文章《删除redo所有日志,数据库无法启动》，于是自己也在测试环境上验证了一下。
删除redo日志后，重新启动后出现以下错误：
SQL> startup
Total System Global Area 1653518336 bytes

Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 23592
Session ID: 237 Serial number: 7

处理方式：

SQL> exit
[oracle@zmotm003 racdb]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 14 21:27:16 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Database mounted.
SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/racdb/redo03.log
/u01/app/oracle/oradata/racdb/redo02.log
/u01/app/oracle/oradata/racdb/redo01.log
/u01/app/oracle/oradata/racdb/RACDB/onlinelog/o1_mf_4_9doqn8tf_.log
/u01/app/oracle/flash_recovery_area/RACDB/onlinelog/o1_mf_4_9doqn964_.log
/u01/app/oracle/oradata/racdb/RACDB/onlinelog/o1_mf_5_9doqn9tz_.log
/u01/app/oracle/flash_recovery_area/RACDB/onlinelog/o1_mf_5_9doqnbh5_.log

7 rows selected.
SQL> alter database clear unarchived logfile group 1;
SQL> alter database clear unarchived logfile group 2;
SQL> alter database clear unarchived logfile group 3;
SQL> alter database open;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> exit

参考
1、删除redo所有日志,数据库无法启动： http://blog.itpub.net/28939273/viewspace-1070222/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29439655/viewspace-1070383/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29439655/viewspace-1070383/