oracle联机重做日志文件丢失&&&&Oracle错误ORA-03113: end-of-file on communication channel处理办法

最新推荐文章于 2024-04-27 02:30:12 发布

rudy_gao

最新推荐文章于 2024-04-27 02:30:12 发布

阅读量1.8k

点赞数

分类专栏： oracle_error backup_recover

本文链接：https://blog.csdn.net/rudygao/article/details/17631837

版权

当Oracle数据库的联机重做日志文件意外删除并强制关闭数据库后，重启时会遇到ORA-03113错误。解决方法包括以挂载模式启动数据库进行修复，或者通过shutdown abort关闭后再重启。

摘要由CSDN通过智能技术生成

一：　1. 在oracle正常运行过程中，强行删除联机重做数据库，而后强制关闭数据库

SQL> host rm -rf '/u01/oradata/orcl/redo01.log'

SQL> shutdown abort;
ORACLE instance shut down

2.而后重启数据库，出现如下错误

SQL> startup
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size		    2217952 bytes
Variable Size		  528484384 bytes
Database Buffers	  301989888 bytes
Redo Buffers		    2412544 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 12350
Session ID: 1 Serial number: 5

此时应以mount方式启动数据库

SQL> startup mount
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size		    2217952 bytes
Variable Size		  528484384 bytes
Database Buffers	  301989888 bytes
Redo Buffers		    2412544 bytes
Database mounted.
SQL> alter database clear logfile group 1;

Database altered.

SQL> alter database open;

二，　以shutdown abort 形式关闭数据库，而后重启数据库，Oracle错误ORA-03113: end-of-file on communication channel处理办法

SQL> startup

ORACLE instance started.

Total System Global Area 1252663296 bytes

Fixed Size 2227944 bytes

Variable Size 704643352 bytes

Database Buffers 536870912 bytes

Redo Buffers 8921088 bytes

Database mounted.

ORA-03113: end - of -file