Oracle error ORA-03113: end-of-file on communication channel solution

Oracle error ORA-03113: end-of-file on communication channel solution machine power-off, oracle cannot start after, error ORA-03113: end-of-file on communication channel (end of the communication channel file)

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: 8117 Session ID: 191 Serial number: 3 online analysis, may be due to the forced shutdown of the Database last night, the file status may be inconsistent, when the database is shut down normally, the files are verified synchronously, so that the file time is consistent during the restart. The solution is as follows: Start 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 limit --------- ---------- --------- 1 112 52428800 1 N OINACTIVE 3826382 16-JUL-13 3857158 17-JUL-13 3 1 114 52428800 512 1 NOCURRENT 3886899 17-JUL-13 2.8147E + 14 2 1 113 52428800 512 1 NOINACTIVE 3857158 17-JUL-13 3886899 17-JUL-13SQL> alter database open resetlogs 2; alter database open resetlogs 2 * ERROR at line 1: ORA-02288: invalid OPEN mode Restore database SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01139: RESETLOGS op Tion only valid after an incomplete database recoverySQL> recover database until time '2017-07-05 'Media recovery complete. SQL> alter database open resetlogs; Database altered. Successful.