Ora-03113
SQL> startupORACLE 例程已经启动。
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有关系。
页:
[1]