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;