Oracle：impdp導(dǎo)入等待statementsuspended,waiterrortobecleared
用數(shù)據(jù)泵impdp往開發(fā)數(shù)據(jù)庫導(dǎo)數(shù)據(jù)，但導(dǎo)入到INDEX時感覺卡住不動了
成都創(chuàng)新互聯(lián)公司堅持“要么做到，要么別承諾”的工作理念，服務(wù)領(lǐng)域包括：成都網(wǎng)站制作、成都網(wǎng)站建設(shè)、企業(yè)官網(wǎng)、英文網(wǎng)站、手機端網(wǎng)站、網(wǎng)站推廣等服務(wù)，滿足客戶于互聯(lián)網(wǎng)時代的科爾沁右翼前網(wǎng)站設(shè)計、移動媒體設(shè)計的需求，幫助企業(yè)找到有效的互聯(lián)網(wǎng)解決方案。努力成為您成熟可靠的網(wǎng)絡(luò)建設(shè)合作伙伴！
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX ----查看狀態(tài)，Completed Objects: 33一直沒有變化。 Import> status Job: SYS_IMPORT_FULL_01 Operation: IMPORT Mode: FULL State: EXECUTING Bytes Processed: 843,222,272 Percent Done: 99 Current Parallelism: 1 Job Error Count: 0 Dump File: /home/oracle/dump/wj_dev%u.dmp Dump File: /home/oracle/dump/wj_dev01.dmp Dump File: /home/oracle/dump/wj_dev02.dmp Dump File: /home/oracle/dump/wj_dev03.dmp Dump File: /home/oracle/dump/wj_dev04.dmp Dump File: /home/oracle/dump/wj_dev05.dmp Dump File: /home/oracle/dump/wj_dev06.dmp Dump File: /home/oracle/dump/wj_dev07.dmp Dump File: /home/oracle/dump/wj_dev08.dmp Dump File: /home/oracle/dump/wj_dev09.dmp Dump File: /home/oracle/dump/wj_dev10.dmp Worker 1 Status: Process Name: DW00 State: EXECUTING Object Schema: ESOP2TEST Object Name: SYS_MSISDNNUMID Object Type: SCHEMA_EXPORT/TABLE/INDEX/INDEX Completed Objects: 33 Worker Parallelism: 1
查看導(dǎo)入任務(wù)對應(yīng)的會話做在等待什么
SQL> select * from DBA_DATAPUMP_JOBS; OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS ---------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ----------------- ----------------- SYS SYS_IMPORT_FULL_01 IMPORT FULL EXECUTING 1 2 4 SQL> select sid,sql_id,event from v$session where action='SYS_IMPORT_FULL_01'; SID SQL_ID EVENT ---------- ------------- ---------------------------------------------------------------- 146 bjf05cwcj5s6p wait for unread message on broadcast channel 295 58rzgvcv6gnjs statement suspended, wait error to be cleared
從上面的查詢中可以看到“statement suspended, wait error to be cleared”等待事件，這個是一個不常見的等待事件。
繼續(xù)查看alert日志，發(fā)現(xiàn)如下報錯：
statement in resumable session 'SYS.SYS_IMPORT_FULL_01.1' was suspended due to ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
看到上面的報錯就能明白為什么導(dǎo)入會卡住不動了，正在導(dǎo)入INDEX，創(chuàng)建索引會使用臨時表空間，但臨時文件太小又沒有設(shè)置自動擴展導(dǎo)致創(chuàng)建索引語句HANG住。啟用臨時文件的自動擴展問題解決：
alter database tempfile '/oradata/dbs/temp01.dbf' autoextend on next 100m;
導(dǎo)入正常：
Import> status Job: SYS_IMPORT_FULL_01 Operation: IMPORT Mode: FULL State: EXECUTING Bytes Processed: 843,222,272 Percent Done: 99 Current Parallelism: 1 Job Error Count: 0 Dump File: /home/oracle/dump/wj_dev%u.dmp Dump File: /home/oracle/dump/wj_dev01.dmp Dump File: /home/oracle/dump/wj_dev02.dmp Dump File: /home/oracle/dump/wj_dev03.dmp Dump File: /home/oracle/dump/wj_dev04.dmp Dump File: /home/oracle/dump/wj_dev05.dmp Dump File: /home/oracle/dump/wj_dev06.dmp Dump File: /home/oracle/dump/wj_dev07.dmp Dump File: /home/oracle/dump/wj_dev08.dmp Dump File: /home/oracle/dump/wj_dev09.dmp Dump File: /home/oracle/dump/wj_dev10.dmp Worker 1 Status: Process Name: DW00 State: EXECUTING Object Schema: SUF3TEST Object Name: IDX_ORDER_MEMBER_CHARACTER_ID Object Type: SCHEMA_EXPORT/TABLE/INDEX/INDEX Completed Objects: 407 Worker Parallelism: 1
名稱欄目：Oracle：impdp導(dǎo)入等待statementsuspended,waiterrortobecleared
文章出自：http://www.chinadenli.net/article12/ggisdc.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供服務(wù)器托管、靜態(tài)網(wǎng)站、用戶體驗、標(biāo)簽優(yōu)化、關(guān)鍵詞優(yōu)化、App開發(fā)
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)
