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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-16 13:13:40 | 查看: 1378| 回复: 0

EXP-00056: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 3, block # 466016)
ORA-01110: data file 3: 'F:\ORACLE\ORADATA\YAYB\USERS01.DBF'



EXP时 导到一个表的时侯就报这个错,请问各位如何处理?


这个是生产库,不敢动啊


执行结果

C:\Documents and Settings\Administrator>dbv file=F:\ORACLE\ORADATA\YAYB\USERS01.
DBF blocksize=8192

DBVERIFY: Release 8.1.7.0.0 - Production on Wed Dec 31 07:37:12 2008

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

DBVERIFY - Verification starting : FILE = F:\ORACLE\ORADATA\YAYB\USERS01.DBF
Block Checking: DBA = 13048928, Block Type = KTB-managed data block
Found block already marked corrupted


DBVERIFY - Verification complete

Total Pages Examined         : 1280000
Total Pages Processed (Data) : 297834
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 222299
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 6007
Total Pages Empty            : 753860
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0

C:\Documents and Settings\Administrator>
C:\Documents and Settings\Administrator>

__________________________________________________________________
__________________________________________________________________


SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = 3 and 466016 between block_id AND block_id + blocks - 1;


TABLESPACE_NAME                SEGMENT_TYPE       OWNER
------------------------------ ------------------ ------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
USERS                          TABLE              YBHT
YL41_BZ



TABLESPACE_NAME                SEGMENT_TYPE       OWNER
------------------------------ ------------------ ------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
USERS                          TABLE              YBHT
YL41_BZ


Export done in US7ASCII character set and US7ASCII NCHAR character set

About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > t

EXP-00011: YBHT.T does not exist
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > ybht.yl41_bz

. . exporting table                        YL41_BZ
EXP-00056: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 3, block # 466016)
ORA-01110: data file 3: 'F:\ORACLE\ORADATA\YAYB\USERS01.DBF'
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >

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

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

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

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

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

GMT+8, 2024-5-19 07:52 , Processed in 0.044951 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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