The cause , The file status may be inconsistent due to abnormal power failure .

SQL> startup
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size                  2213896 bytes
Variable Size             956303352 bytes
Database Buffers          687865856 bytes
Redo Buffers                7135232 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 2874
Session ID: 192 Serial number: 5

terms of settlement

SQL> conn / as sysdba    ### Super administrator entered
Connected to an idle instance.
SQL> startup mount;       ### Mount database
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size                  2213896 bytes
Variable Size             956303352 bytes
Database Buffers          687865856 bytes
Redo Buffers                7135232 bytes
Database mounted.
SQL> select * from v$log;  ### Check the log

GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------------- ------------- --------- ------------ ---------
         1          1        124   52428800        512          1 NO
INACTIVE               3674510 31-AUG-16      3691896 31-AUG-16

3          1        126   52428800        512          1 NO
CURRENT                3728411 01-SEP-16   2.8147E+14

2          1        125   52428800        512          1 NO
INACTIVE               3691896 31-AUG-16      3728411 01-SEP-16

SQL> recover database until time '2016-09-01';  ### Recovery media to 2016-09-1  We can deal with it before that session The time format makes it easy to accurately locate the log time alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
Media recovery complete.

SQL> alter database open resetlogs;                 ### Start database to open state // Reference resources http://blog.csdn.net/liqfyiyi/article/details/8046557

Database altered.

ORA-03113: end-of-file on communication channel More articles about

  1. ORA-03113: end-of-file on communication channel resolvent

    Today, a large amount of data is inserted into a table in the test database , Causing the database to jam hang live , After restarting the database, an error is reported as follows : C:\Documents and Settings\davidd>sqlplus " ...

  2. ORA-03113: end-of-file on communication channel The disk is slow , Database startup failed

    The disk is slow , Database startup failed : Solutions :1. Let the data file offline: 2. Delete tablespace SQL> startup pfile='/server/oracle/admin/test/pfile/init ...

  3. ASM The path problem causes the database not to start normally -- newspaper :ORA-03113: end-of-file on communication channel

    Description of the environment : Operating system version :Red Hat Enterprise Linux Server release 6.5 (Santiago) Database version :Oracle 11.2.0.4 RAC Scene description : ...

  4. ORA-03113 : end-of-file on communication channel

    Phenomenon one : database startup when , The database is not working properly mount, Consolidated report ORA-03113 error . SQL> startup ORACLE instance started. Total System ...

  5. Oracle error ORA-03113: end-of-file on communication channel Treatment method

    oracle It can't start , Report errors ORA-03113: end-of-file on communication channel ( The end of the communication channel file ) terms of settlement : SQL> startup ORAC ...

  6. ORACLE Initiate error reporting ORA-03113: end-of-file on communication channel

    It was found that oracle Running very slow ( In fact, we should pay attention to space first ), Just ready to shut down and restart , If you can't turn it off, force it off , And then it starts up with an error . 1.SQL> startup ORACLE instance starte ...

  7. ORA-03113: end-of-file on communication channel( How to deal with the problem )

    File in flash_recovery Catalog , Because the archive is full of flashback directories , Database startup error ORA-03113: end-of-file on communication channel tail -1200f ...

  8. ORA-03113 ---end-of-file on communication channel Solution records

    ORALCE The following error occurred during startup : ORA-03113: end-of-file on communication channel     The solution is as follows : 1. see orcle start log , Determine the specific reason ...

  9. ORA-03113: end-of-file on communication channel Solution

    Oracle The following error occurred during startup :ORA-03113: end-of-file on communication channel   The solution is as follows :1. see orcle start log , Determine exactly what caused the error . ...

Random recommendation

  1. mandatory QQ Good friends

    tencent://AddContact/?fromId=45&fromSubId=1&subcmd=all&uin=32595667&website=www.oicq ...

  2. C++ Name conflict in "y1"

    It's the second time I've had this problem : #include <bits/stdc++.h> using namespace std; ); ][N][][N]; int x1, x2, y1, y2; ...

  3. 【Qt】QDialog The shield Esc key 【 turn 】

    sketch Qt in Esc Key will trigger some events by default in some controls , such as :QDialog, Press down Esc The key window disappears . Most of the time , We don't need to , Then you need to mask the default Events . sketch Source code analysis Event filter event ...

  4. 【LeetCode 229】Majority Element II

    Given an integer array of size n, find all elements that appear more than ⌊ n/3 ⌋ times. The algorit ...

  5. Use paramiko Carry out packing operation

    Use paramiko perform ssh There's a big hole in the order : It can't accurately identify your system environment variables , So when you use some commands, you'll find , When executing the command directly in the system, you can , But instead paramiko When executing, it will report an error and say ...

  6. RDD Mechanism implementation model Spark First time to know

    Spark brief introduction Spark It's a big data distributed computing framework based on memory computing .Spark Based on memory computing , It improves the real-time performance of data processing in the big data environment , At the same time, it ensures high fault tolerance and high scalability .       stay Spark in , adopt RDD( ...

  7. Java encryption algorithm AES

    Copyright notice : This article is an original blog article , Reprint please indicate the source . [java] view plain copy print? stay CODE View the code slice on the screen and derive it to my code slice package com.stone.security; ...

  8. Wechat apps vs progressive-web-apps

    https://developers.google.com/web/progressive-web-apps/

  9. JSONObject and JSONArray Simple use (json-lib)

    One . jar package commons-lang.jar commons-beanutils.jar commons-collections.jar commons-logging.jar ezmorph.j ...

  10. php series

    1. to Run in the windows In the environment php, install redis expand .(installing Redis & Redis extension in PHP on XAMPP on windows ...