ORA-03113: File end of communication channel error resolution

Today, when the server shut down the inexplicable reason for the database can not be shutdown, forced to use the Force command shutdown abort, but the random Oracle database can not open, always reported "ORA-03113: Communication channel file End" error, Analysis may cause the file status to be inconsistent because the database is shut down immediately, because a normal shutdown of the database in conjunction with the files, so that the time to restart the file is consistent and do not have to crash recovery, have to do the following recovery, we recommend that you later in the use of the Abort option, Look at IO status on the OS first, and then force the shutdown when IO value is 0 or close to 0 to avoid unpredictable errors. (My environment is Oracle 11g,centos 5.4)

sql> startup Mount;
The ORACLE routine has started.

Total System Global area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 637536288 bytes
Database buffers 188743680 bytes
Redo buffers 6606848 bytes
Database loading complete.
sql> ALTER DATABASE open;
ALTER DATABASE Open
*
Line 1th Error:
ORA-03113: End of file for communication channel
Process id:4272
Session id:125 Serial Number: 5

Sql> Conn '/as SYSDBA '
You are connected to an idle routine.
Sql> Startup Mount
The ORACLE routine has started.

Total System Global area  835104768 bytes
Fixed Size                 & nbsp;2217952 bytes
Variable Size             637536288 bytes
Database buffers          188743680 bytes
Redo buffers                660684 8 bytes
The database has finished loading.
Sql> SELECT * from V$log;

   group#    thread#  sequence#      bytes  blocksize     Members ARC
---------------------------------------------------------------
STATUS       &NBS P   first_change# first_time     next_change# next_time
-------------------------------------------- -------------------------
        1          1       &NBS P   52428800        512          1 NO
INACTIVE              12980317 July-September -10         12988303 July-September -10

3 1 52428800 1 NO
Current 12991762 July-September -10 2.8147E+14

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

2 1 52428800 1 NO
INACTIVE 12988303 July-September-10 12991762 July-September-10

sql> ALTER DATABASE open resetlogs;
ALTER DATABASE open Resetlogs
*
Line 1th Error:
The ora-01139:resetlogs option is only valid after incomplete database recovery

sql> recover database until time ' 2010-09-09 1:45:02 ';
Complete media recovery.
sql> ALTER DATABASE open resetlogs;

The database has changed.

sql> shutdown
The database has been closed.
The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has started.

Total System Global area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 637536288 bytes
Database buffers 188743680 bytes
Redo buffers 6606848 bytes
Database loading complete.
The database is already open.
Sql>

This article comes from "Life is not, fighting is endless!" "Blog, please be sure to keep this source http://soulful.blog.51cto.com/468033/389570