Oracle錯誤ORA-03113: end-of-file on communication channel處理辦法

標籤：

oracle不能啟動了，報錯ORA-03113: end-of-file on communication channel （通訊通道的檔案結尾）

解決辦法：

SQL> startupORACLE instance started. Total System Global Area 1252663296 bytesFixed Size 2227944 bytesVariable Size 704643352 bytesDatabase Buffers 536870912 bytesRedo Buffers 8921088 bytesDatabase mounted.ORA-03113: end-of-file on communication channelProcess ID: 8117Session ID: 191 Serial number: 3網上分析，可能由於昨晚資料庫強制關閉，導致檔案狀態可能不一致，因為正常關閉資料庫會同步校正各檔案，使得重新啟動的時候檔案時間點一致。解決方案如下啟動DBSQL> conn / as sysdbaConnected to an idle instance. SQL> startup mountORACLE instance started.SQL> select * from v$log;     GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC---------- ---------- ---------- ---------- ---------- ---------- ---STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME---------------- ------------- --------- ------------ ---------         1 1 112 52428800 512 1 NOINACTIVE 3826382 16-JUL-16 3857158 17-JUL-16          3 1 114 52428800 512 1 NOCURRENT 3886899 17-JUL-16 2.8147E+14          2 1 113 52428800 512 1 NOINACTIVE 3857158 17-JUL-16 3886899 17-JUL-16  SQL> alter database open resetlogs 2;alter database open resetlogs 2                              *ERROR at line 1:ORA-02288: invalid OPEN mode恢複資料庫SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01139: RESETLOGS option only valid after an incomplete database recovery  SQL> recover database until time ‘2016-08-05‘Media recovery complete.SQL> alter database open resetlogs; Database altered.成功。

　　

Oracle錯誤ORA-03113: end-of-file on communication channel處理辦法