The machine suffers a power outage, then Oracle can't start, error ora-03113:end-of-file on communication channel (end of file of communication channel)
Sql> Conn/as SYSDBA
Connected to a idle instance.
Sql> Startup
ORACLE instance started.
Total System Global area 417546240 bytes
Fixed Size 2213936 bytes
Variable Size 398460880 bytes
Database buffers 8388608 bytes
Redo buffers 8482816 bytes
Database mounted.
Ora-03113:end-of-file on communication channel
Process id:2517
Session id:1137 Serial Number:5
Online analysis, may be due to the database forced shutdown last night, resulting in file status may be inconsistent, because the normal shutdown database in conjunction with the verification of the files, so that the time to restart the file point of view consistent. The solution is to start db as follows
Sql> exit
[Oracle@izwz94iiauukqd0inyhirbz ~]$ Sqlplus/nolog
Sql*plus:release 11.2.0.1.0 Production on Mon Nov 14 13:25:52 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Sql> Conn/as SYSDBA
Connected to a idle instance.
Sql> Startup Mount
ORACLE instance started.
Total System Global area 417546240 bytes
Fixed Size 2213936 bytes
Variable Size 398460880 bytes
Database buffers 8388608 bytes
Redo buffers 8482816 bytes
Database mounted.
Sql> select * from V$log;
group# thread# sequence# BYTES BLOCKSIZE members ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS first_change# First_time next_change#
---------------- ------------- ------------------ ------------
Next_time
------------------
1 1 151 52428800 1 NO
INACTIVE 4428274 13-nov-16 4460292
13-nov-16
3 1 153 52428800 1 NO
Current 4486336 13-nov-16 2.8147E+14
group# thread# sequence# BYTES BLOCKSIZE members ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS first_change# First_time next_change#
---------------- ------------- ------------------ ------------
Next_time
------------------
2 1 152 52428800 1 NO
INACTIVE 4460292 13-nov-16 4486336
13-nov-16
sql> ALTER DATABASE open resetlogs;
ALTER DATABASE open Resetlogs
*
ERROR at line 1:
Ora-01139:resetlogs option Valid after a incomplete database recovery
sql> r ecover Database until time ' 2016-11-13 '
Media recovery complete.
sql> ALTER DATABASE open resetlogs;
Database altered. Success.