- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-13 12:34:53
|
查看: 1277 |
回复: 0
错误 ORA-03113: 通信通道的文件结尾
进程 ID: 2780
会话 ID: 351 序列号: 3
下面是trace的内容,
2017-01-11 18:40:34.921
*** SESSION ID351.3) 2017-01-11 18:40:34.921
*** CLIENT ID) 2017-01-11 18:40:34.921
*** SERVICE NAME) 2017-01-11 18:40:34.921
*** MODULE NAMEsqlplus.exe) 2017-01-11 18:40:34.921
*** ACTION NAME) 2017-01-11 18:40:34.921
Thread 1 checkpoint: logseq 79, block 2, scn 16392223
cache-low rba: logseq 79, block 3
on-disk rba: logseq 79, block 2550, scn 16392519
start recovery at logseq 79, block 3, scn 0
*** 2017-01-11 18:40:35.703
Started writing zeroblks thread 1 seq 79 blocks 2573-2580
*** 2017-01-11 18:40:35.703
Completed writing zeroblks thread 1 seq 79
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 1285Kb in 0.78s => 1.61 Mb/sec
Longest record: 2Kb, moves: 0/4709 (0%)
Longest LWN: 149Kb, moves: 0/105 (0%), moved: 0Mb
Last redo scn: 0x0000.00fa2155 (16392533)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 178/178 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 9421/9599 = 1.0
----------------------------------------------
*** 2017-01-11 18:40:35.734
KCRA: start recovery claims for 178 data blocks
*** 2017-01-11 18:40:35.796
KCRA: blocks processed = 178/178, claimed = 178, eliminated = 0
*** 2017-01-11 18:40:35.812
Recovery of Online Redo Log: Thread 1 Group 1 Seq 79 Reading mem 0
*** 2017-01-11 18:40:35.937
Completed redo application of 1.04MB
*** 2017-01-11 18:40:35.937
Completed recovery checkpoint
IR RIA: redo_size 1315840 bytes, time_taken 95 ms
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 178/178 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 9599/9599 = 1.0
----------------------------------------------
Recovery sets nab of thread 1 seq 79 to 2573 with 8 zeroblks
*** 2017-01-11 18:40:39.546
kwqmnich: current time:: 10: 40: 39: 0
kwqmnich: instance no 0 repartition flag 1
kwqmnich: initialized job cache structure
kwqinfy: Call kwqrNondurSubInstTsk
|
|