oracle expdp/exp ora-600/ora-39014报错处理( 二 ) _生活百科

【oracle expdp/exp ora-600/ora-39014报错处理】*** 2022-10-23 13:11:09.139kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:12:31.092kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:12:48.842kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:12:49.998kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:12:52.154kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:12:55.826kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:12:56.326kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:12:57.076kwqberlst 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 kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:12:58.420kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:12:59.170kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:13:01.826kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:13:02.186kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:13:04.295kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
*** 2022-10-23 13:13:05.170kwqberlst 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 Incident 104071 created, dump file: d:\oracle\administrator\diag\rdbms\ttfc\ttfc\incident\incdir_104071\ttfc_dm00_11104_i104071.trc
*** 2022-10-23 13:26:35.249ORA-31671: Worker 进程 DW00 有未处理的异常错误。ORA-00600: 内部错误代码, 参数: [kupfiWriteLob_1], [], [], [], [], [], [], [], [], [], [], []ORA-06512: 在 "SYS.KUPW$WORKER", line 1712ORA-06512: 在 line 2
KUPP: Exiting kuppqwemkwqberlst 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:26:37.405kwqberlst rqan->lascn_kwqiia > 0 block kwqberlst rqan->lascn_kwqiia7 kwqberlst ascn -1443654893 lascn 22
其他trc文件

文章插图

文章插图
首先第一感觉就是BUG，因为oracle版本太旧了，但是我还是尝试用其他办法处理，尽量不升级，毕竟不是所有环境都能升级，有些废弃的环境也完全不需要升级。
我尝试用exp导出

文章插图
导出失败，但是我以外的发现有提到统计信息的导出失败，所以我加上 statistics=none,再次用exp 导出也不行。我觉得不要所有报错提升都去看support,应该培养自己的正确思维方式，然后我想既然跟统计信息有关，干脆试一下用expdp 导出，互虐统计信息再试一下，expdp 加上参数 EXCLUDE=STATISTICS 然后神奇的一幕发生了，可以导出，并且没有报错。

文章插图
后面用support 查看到Doc ID 1982596.1
果然是BUG，Bug 11656163 ，是由于有大文件对象，超过4G，在（11.2.0.3，12.1.0.1）版本修复改BUG 。
The bug is a.o. fixed in
12.1.0.1 (Base Release)11.2.0.3 (Server Patch Set)
查看表段的大小
SELECT SEGMENT_NAME, ROUND(SUM(BYTES / 1024 / 1024 / 1024), 2) GFROM DBA_SEGMENTS WHERE SEGMENT_NAME IN(SELECT TABLE_NAME FROM USER_TAB_COLUMNS WHERE DATA_TYPE = 'CLOB') GROUP BY SEGMENT_NAME ORDER BY 2 DESC;