ORA-03113: End of the file for the communication channel (error resolved)

Source: Internet
Author: User
When the server is shut down, the database cannot be shut down due to an unknown reason, so we have to use the force command shutdownabort. However, if the Oracle database cannot be opened, it always reports

When the server is shut down, the database cannot be shut down due to an unknown reason, so you have to use the force command shutdown abort. However, if the Oracle database cannot be opened, it always reports

When I shut down the server today, the database could not be shut down due to inexplicable reasons, so I had to use the Forced Command shutdown abort; but casually Oracle database could not open, always reported "ORA-03113: the "end" of the file in the communication channel is incorrect. The analysis may be caused by the database being closed immediately, which may result in inconsistent file statuses. If the database is closed normally, the files will be verified synchronously, in this way, when the files are restarted at the same time, and no crash recovery is required, we have to perform the following restoration. We recommend that you observe the IO status on the OS in the future when using the abort option, disable it when the IO value is 0 or close to 0 to avoid unexpected errors. (My environment is Oracle 11g, CentOS 5.4)

SQL> startup mount;
The ORACLE routine has been started.

Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 637536288 bytes
Database Buffers 188743680 bytes
Redo Buffers 6606848 bytes
The database has been loaded.
SQL> alter database open;
Alter database open
*
Row 3 has an error:
ORA-03113: End of the file for the communication channel
Process ID 4272
Session ID: 125 serial number: 5

SQL> conn'/as sysdba'
Already connected to the idle routine.
SQL> startup mount
The ORACLE routine has been started.

Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 637536288 bytes
Database Buffers 188743680 bytes
Redo Buffers 6606848 bytes
The database has been loaded.
SQL> select * from v $ log;

GROUP # THREAD # SEQUENCE # BYTES BLOCKSIZE MEMBERS ARC
---------------------------------------------------------------
STATUS FIRST_CHANGE # FIRST_TIME NEXT_CHANGE # NEXT_TIME
---------------------------------------------------------------------
1 1 97 52428800 512 1 NO
INACTIVE 12980317 month-10 12988303 month-10

3 1 99 52428800 512 1 NO
CURRENT 12991762-9-10 2.8147E + 14

2 1 98 52428800 512 1 NO
INACTIVE 12988303 month-10 12991762 month-10

SQL> alter database open resetlogs;
Alter database open resetlogs
*
Row 3 has an error:
ORA-01139: The RESETLOGS option is valid only after Incomplete Database recovery

SQL> recover database until time '2017-09-09 1:45:02 ';
Media recovery is completed.
SQL> alter database open resetlogs;

The database has been changed.

SQL> shutdown
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.
SQL> startup
The ORACLE routine has been started.

Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 637536288 bytes
Database Buffers 188743680 bytes
Redo Buffers 6606848 bytes
The database has been loaded.
The database has been opened.
SQL>

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.