在一次数据迁移的时候,expdp导出报错,错误信息如下:
![oracle expdp/exp ora-600/ora-39014报错处理](http://img.zhejianglong.com/231018/20544R006-0.png)
文章插图
版本号:11.2.0.1
![oracle expdp/exp ora-600/ora-39014报错处理](http://img.zhejianglong.com/231018/20544RF9-1.png)
文章插图
没有打PSU,查看报错的aler部分日志如下:
![oracle expdp/exp ora-600/ora-39014报错处理](http://img.zhejianglong.com/231018/20544V945-2.jpg)
文章插图
其中的某一些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
*** 2022-10-23 13:11:04.232kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:11:05.576kwqberlst 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
*** 2022-10-23 13:11:06.139kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
推荐阅读
- [Oracle]复习笔记-SQL部分内容
- 关于Springboot启动报错 Whitelabel Error Page: This application has no explicit mapping
- Explain:你见过这样的Sql吗?
- liunx之expect简介
- liunx之expect操作详解
- oracle中的行转列,列转行
- 条件期望:Conditional Expectation 举例详解之入门之入门之草履虫都说听懂了
- 万年青 wnq
- explorer exe错误怎么办 Explorerexe错误怎么解决
- oracle创建用户名 oracle创建用户怎么做