环境：linux平台，oracle11.2.0.4.0单实例
导出命令：expdp noap/uwaysoft2014 parfile=cfg_normal_tables.cfg cluster=N parallel=4
cfg_normal_tables.cfg文件内容：
COMPRESSION=ALL
REUSE_DUMPFILES=Y
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=auto_backup_20190429.dmp
LOGFILE=auto_backup_20190429.log
TABLES=(
table1,
table2）
报错日志：
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Starting "user"."SYS_EXPORT_TABLE_01": user/******** parfile=cfg_normal_tables.cfg
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.744 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [INDEX:"NOAP"."PK_CFG_PARA_FIELD_LIB2"]
ORA-01555: snapshot too old: rollback segment number 28 with name "_SYSSMU28_4035073970$" too small
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9715
----- PL/SQL Call Stack -----
object line object
handle number name
0x2a5eaae360 21979 package body SYS.KUPW$WORKER
0x2a5eaae360 9742 package body SYS.KUPW$WORKER
0x2a5eaae360 11838 package body SYS.KUPW$WORKER
0x2a5eaae360 2808 package body SYS.KUPW$WORKER
0x2a5eaae360 10422 package body SYS.KUPW$WORKER
0x2a5eaae360 1824 package body SYS.KUPW$WORKER
0x2abadba948 2 anonymous block
Job "user"."SYS_EXPORT_TABLE_01" stopped due to fatal error at Sun Apr 28 18:21:45 2019 elapsed 0 02:04:29
尝试修改undo_retention=3600,但还是报错，麻烦老师们帮忙指导一下，十分感谢！
不好意思，tables=(table1,table2)这里面有800多张表，由于是生产系统所以我把表名简化了。在导出的时候，我查了等待事件，有个导出查询的sql一直在执行，sql如下：
SELECT /*+all_rows*/
SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T', '7')),
KU$.OBJ_NUM,
KU$.ANC_OBJ.NAME,
KU$.ANC_OBJ.OWNER_NAME,
KU$.ANC_OBJ.TYPE_NAME,
KU$.SCHEMA_OBJ.NAME,
KU$.SCHEMA_OBJ.NAME,
'INDEX',
KU$.PROPERTY,
KU$.SCHEMA_OBJ.OWNER_NAME,
KU$.TS_NAME,
to_char(KU$.TYPE_NUM),
decode(cardinality(KU$.COL_LIST), 0, '1', '0')
FROM SYS.KU$_INDEX_VIEW KU$
WHERE NOT KU$.FOR_PKOID = 1
AND NOT KU$.FOR_REFPAR = 1
AND NOT (KU$.TYPE_NUM = 1 AND KU$.INTCOLS = 1 AND KU$.OID_OR_SETID != 0)
AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128) != 0
AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 4) = 4
AND KU$.BASE_OBJ_NUM IN
(SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001)))
AND KU$.SCHEMA_OBJ.OWNER_NAME IN
(SELECT UNIQUE object_schema
FROM "NOAP"."SYS_EXPORT_TABLE_02"
WHERE process_order = -55
AND duplicate BETWEEN 1 AND 878)
AND KU$.TYPE_NUM NOT IN (2, 4, 8, 9)
AND BITAND(KU$.PROPERTY, 16) != 16
还麻烦老师帮忙分析一下，感谢
评论
有用 0这个问题之前在做XTTS迁移的时候遇到过几次，导出元数据都非常慢，11203和11204上的bug，11204需要安装补丁19674521，或者是安装最新的补丁集PSU。
也可以改用exp导出。
评论 有用 0
墨值悬赏