- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-16 13:13:40
|
查看: 1639 |
回复: 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. |
|