PRCR-1079 : 无法启动资源 ora.orcl.db ORA-03113: end-of-file on communication channel

最新推荐文章于 2026-05-12 10:39:46 发布

原创最新推荐文章于 2026-05-12 10:39:46 发布 · 8.1k 阅读

9 ·

本内容遵循CC 4.0 BY-SA版权协议

学习问题总结专栏收录该内容

36 篇文章

订阅专栏

本文详细解析了在使用srvctl start database 命令启动数据库时遇到ORA-03113错误的原因，并提供了具体的排查步骤和解决方案，包括检查日志文件、执行SQL命令、强制启动数据库以及最终的数据库重建操作。

[grid@rac2 ~]$ srvctl start database -d orcl
PRCR-1079 : 无法启动资源 ora.orcl.db
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-03113: end-of-file on communication channel
Process ID: 21123
Session ID: 63 Serial number: 3
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/rac1/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.orcl.db' on 'rac1' failed
CRS-2632: There are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-03113: end-of-file on communication channel
Process ID: 19773
Session ID: 63 Serial number: 3
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/rac2/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.orcl.db' on 'rac2' failed

强制启动

SQL>alter database open;

alter database open
*
ERROR 位于第 1 行:
ORA-01113: 文件 1 需要介质恢复
ORA-01110: 数据文件 1: 'E:\ORACLE\ORADATA\OEMREP\SYSTEM01.DBF'

SQL> alter database open;
alter database open
*
ERROR 位于第 1 行:
ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项

查找没有resetlogshenoresetlogs，

最后是删除数据库重新创建新库

删除数据库:
/u01/app/oracle/product/11.2.0/db_1/deinstall deinstall