oracle ORA-03113 打开数据库时出错
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/20649208/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ORA-03113 Error while opening the database
提问by naresh
I am trying to restore a database. The job was hung do to some issue, so I have restarted the Oracle service (Windows). I'm now getting an error while connecting to DB:
我正在尝试恢复数据库。该作业因某些问题而挂起，因此我重新启动了 Oracle 服务 (Windows)。我现在在连接到数据库时遇到错误：
ORA-03113 end-of-file on communication channel
Process ID :9716
Session ID: 237 serial number :5
How can I solve this error?
我该如何解决这个错误？
回答by RGO
ORA-03113is a generic error. Please read this excellent post herefor some information as to the root cause analysis of this error.
ORA-03113是一般错误。请在此处阅读这篇出色的文章，了解有关此错误根本原因分析的一些信息。
As a workaround for your case, assuming you can afford to reset the logs, you can probably do an incomplete database recovery and then open the database with RESETLOGSoption:
作为您的情况的解决方法，假设您有能力重置日志，您可能可以进行不完整的数据库恢复，然后使用以下RESETLOGS选项打开数据库：
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;
SQL> ALTER DATABASE RECOVER CANCEL;
SQL> ALTER DATABASE OPEN RESETLOGS;
回答by Udoye thedi
try this
尝试这个
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;
SQL> ALTER DATABASE OPEN RESETLOGS;
回答by mario
it helped to me.
它对我有帮助。
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;
SQL> ALTER DATABASE OPEN RESETLOGS;
