ORA-39126: Worker unexpected fatal error ..
1、1：记录源库用户规则
导出库：
1 SA REMOTE320DB TEMP DEFAULT
2 ZXX REMOTE320DB TEMP DEFAULT
2、2：进行用户导出
create directory dump_dir as '/home/oracle/dir_dump';
grant read,write on directory dump_dir to zxx;
expdp zxx/zxx schemas=sa directory=dump_dir parallel=6 dumpfile=sa_20150922_U.dmp logfile=sa_20150922.log
orcl:/home/oracle@jkdb>expdp zxx/zxx schemas=sa directory=dump_dir parallel=6 dumpfile=sa_20150922_U.dmp logfile=sa_20150922.log
Export: Release 11.2.0.3.0 - Production on Wed Sep 23 09:02:08 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "ZXX"."SYS_EXPORT_SCHEMA_01": zxx/******** schemas=sa directory=dump_dir parallel=6 dumpfile=sa_20150922_U.dmp logfile=sa_20150922.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 13.72 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/JOB
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN [TABLE_DATA:"SA"."DLJK_ZPXX"] ---->DLJK_ZPXX读取报错
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 9826
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 3340
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 15486
ORA-02354: error in exporting/importing data
ORA-01115: IO error reading block from file (block # )
ORA-01115: IO error reading block from file 5 (block # 5506)
ORA-27072: File I/O error
Additional information: 4
Additional information: 5506
Additional information: 843776
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001
----- PL/SQL Call Stack -----
object line object
handle number name
0x1583c3940 20462 package body SYS.KUPW$WORKER
0x1583c3940 9028 package body SYS.KUPW$WORKER
0x1583c3940 1829 package body SYS.KUPW$WORKER
0x156869098 2 anonymous block
Job "ZXX"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 09:15:07
可以看到报错很明显，DLJK_ZPXX表读取报错，在plsql查询时，发现数据文件损坏。但是还能够查询到部分数据。
3、3：导出时过滤问题表
expdp zxx/zxx schemas=sa directory=dump_dir parallel=6 dumpfile=sa_20150923_U.dmp EXCLUDE=TABLE:\"IN \(\'DLJK_ZPXX\' \)\" logfile=sa_20150922.log;
发现还是报错，可以看到DLJK_CLGJXX部分数据读取报错。通过一个一个排除，发现只有两张大表有问题。只能够把两张表过滤掉了。
expdp zxx/zxx schemas=sa directory=dump_dir parallel=6 dumpfile=sa_20150923_U.dmp EXCLUDE=TABLE:\"IN \(\'DLJK_ZPXX\' ,\'DLJK_CLGJXX\'\)\" logfile=sa_20150922.log;
4、4：通过query导出问题表的正常部分数据
1：首先通过query导出问题表的部分数据和表结构，这时候CONTENT=ALL
2：然后通过query导出问题表的其他部分正常数据，这时候CONTENT=DATA_ONLY
数据导入很简单，这里不做讲诉了。