oracle expdp/exp ora-600/ora-39014报错处理

在一次数据迁移的时候,expdp导出报错,错误信息如下:

oracle expdp/exp ora-600/ora-39014报错处理

文章插图
版本号:11.2.0.1
oracle expdp/exp ora-600/ora-39014报错处理

文章插图
没有打PSU,查看报错的aler部分日志如下:
oracle expdp/exp ora-600/ora-39014报错处理

文章插图
其中的某一些trc日志文件截图:
Trace file d:\oracle\administrator\diag\rdbms\ttfc\ttfc\trace\ttfc_dm00_11104.trcOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsWindows NT Version V6.2CPU: 8 - type 8664, 4 Physical CoresProcess Affinity: 0x0x0000000000000000Memory (Avail/Total): Ph:4813M/15359M, Ph+PgF:11787M/23551M Instance name: ttfcRedo thread mounted by this instance: 1Oracle process number: 42Windows thread id: 11104, image: ORACLE.EXE (DM00)
*** 2022-10-23 12:39:28.872*** SESSION ID:(204.20873) 2022-10-23 12:39:28.872*** CLIENT ID:() 2022-10-23 12:39:28.872*** SERVICE NAME:(SYS$USERS) 2022-10-23 12:39:28.872*** MODULE NAME:(Data Pump Master) 2022-10-23 12:39:28.872*** ACTION NAME:(SYS_EXPORT_SCHEMA_01) 2022-10-23 12:39:28.872 KUPC: Setting remote flag for this process to FALSEprvtaqis - Enter prvtaqis subtab_name upd prvtaqis sys table upd KUPP: Initialization complete for master process DM00
*** 2022-10-23 12:39:29.294kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654899 lascn 22 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654899 lascn 22 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654899 lascn 22 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654899 lascn 22 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654899 lascn 22 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654899 lascn 22 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654899 lascn 22 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654899 lascn 22 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654899 lascn 22 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654899 lascn 22 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654757 lascn 22 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22 kwqberlst rqan->lascn_kwqiia > 0 block
*** 2022-10-23 13:11:01.717kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:11:02.170kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654757 lascn 22 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst !retval block kwqberlst rqan->lagno_kwqiia7 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22

经验总结扩展阅读