Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-13 12:34:53 | 查看: 1276| 回复: 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


下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 13:17 , Processed in 0.043965 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569