Ora-03113

ALLSTARS_ORACLE

SQL> startup
ORACLE 例程已经启动。

Total System Global Area 1720328192 bytes
Fixed Size                  2176448 bytes
Variable Size            1291848256 bytes
Database Buffers          419430400 bytes
Redo Buffers                6873088 bytes
数据库装载完毕。
ORA-03113: 通信通道的文件结尾
进程 ID: 12
会话 ID: 125 序列号: 5

官方error定义：
ORA-03113: end-of-file on communication channel
Cause: The connection between Client and Server process was broken.
Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

告警日志中信息：
WARNING! Detected a split brain in thread 1
Terminating instance.
USER (ospid: 1920): terminating the instance
Instance terminated by USER, pid = 1920


请问怎么解决。告警日志中没有关于闪回区大小的error。



SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME     NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------- ------------ --------------
         1          1          1   52428800        512          1 NO  CURRENT             2354233948 12-6月 -16       2.8147E+14
         3          1          0   52428800        512          1 YES UNUSED                       0                   0
         2          1          0   52428800        512          1 YES UNUSED                       0                   0



Started redo application at
Thread 1: logseq 1, block 2, scn 2354233951
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
Completed redo application of 0.00MB
Completed crash recovery at
Thread 1: logseq 1, block 3, scn 2354253953
0 data blocks read, 0 data blocks written, 0 redo k-bytes read
WARNING! Detected a split brain in thread 1
Terminating instance.
USER (ospid: 588): terminating the instance
Instance terminated by USER, pid = 588

告警日志显示应该是和redo有关系。