表空间传输报错
wxfg 2017-06-02 04:25:35 aix6.1+oracle 10.2.0.3
用rman transport tablespace语句,自动从备份文件进行表空间传输,进行到最后一步expdp自动导出元数据时,经常报错如下,但是偶尔能成功完成
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE:"COMM"."LAB_SURCHARGE"]
ORA-01555: snapshot too old: rollback segment number 0 with name "SYSTEM" too small
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6234
----- PL/SQL Call Stack -----
object line object
handle number name
70000003fa68b08 14916 package body SYS.KUPW$WORKER
70000003fa68b08 6293 package body SYS.KUPW$WORKER
70000003fa68b08 2339 package body SYS.KUPW$WORKER
70000003fa68b08 6854 package body SYS.KUPW$WORKER
70000003fa68b08 1259 package body SYS.KUPW$WORKER
70000003f8cc440 2 anonymous block
Job "SYS"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at 06:49:11
已经试过将自动恢复的辅助实例的undo_management设置为auto,调整UNDO_RETENTION,都无效
翻遍了oracle metalink
找到 Bug 5612569 : EXPDP FAILURE DURING TRANSPORTABLE TABLESPACE: ORA-39125 ORA-1555
Bug 9109785 : ORA-1555 TRANSPORT TABLESPACE FAILS WITH ORA-01555 DURING THE EXPDP PHASE
都没有解决方法