Oracle error Ora-03113:end-of-file on communication channel handling method

Source: Internet
Author: User

Oracle cannot start, error ora-03113:end-of-file on communication channel (end of file for communication channel)

Workaround:

Sql> Startuporacle instance started. Total System Global area 1252663296 bytesfixed size 2227944 bytesvariable size 704643352 bytesdatabase buffers 536870912 b Ytesredo buffers 8921088 bytesdatabase mounted. Ora-03113:end-of-file on communication channelprocess id:8117session id:191 Serial number:3 Online analysis, may be due to the database forced shutdown last night, resulting in file status can be Can be inconsistent, because the normal shutdown database is synchronized with the files, so that the time when the file is restarted. The solution starts as follows 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---------------------------------------------------------------S         Tatus first_change# first_tim next_change# next_time----------------------------------------------------------- 1 1 52428800 1 noinactive 3826382 16-jul-16 3857158 17-jul-16 3 1 52428800 1 nocurrent 3886899 17-jul-16 2.8147E+14 2 1 113 52428800 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 restore sql> ALTER DATABASE open Resetlogs;alter DB open resetlogs*error at line 1:ora-01139:resetlogs option O Nly valid after an incomplete database recovery sql> recover database until time ' 2016-08-05 ' Media recovery complete.s ql> ALTER DATABASE open resetlogs; Database altered. Success.

  

Oracle error Ora-03113:end-of-file on communication channel handling method

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.