Shulou(Shulou.com)06/01 Report--

Use the data pump impdp to transfer data to the development database, but it feels stuck when it is imported into INDEX.

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX---- check status, Completed Objects: 33 has not changed. Import > statusJob: SYS_IMPORT_FULL_01 Operation: IMPORT Mode: FULL State: EXECUTING Bytes Processed: 843222272 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

Check what the session corresponding to the import task is waiting for

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 4SQL > select sid Sql_id,event from v$session where action='SYS_IMPORT_FULL_01' SID SQL_ID EVENT- 146bjf05cwcj5s6p wait for unread message on broadcast channel 29558rzgvcv6gnjs statement suspended, wait error to be cleared

You can see the "statement suspended, wait error to be cleared" wait event from the above query, which is an unusual wait event.

Continue to check the alert log and find the following error:

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

If you see the error above, you can understand why the import is stuck, INDEX is being imported, and temporary tablespaces are used to create indexes, but the temporary file is too small and does not set up automatic extension, which leads to the creation of index statements HANG. Enable automatic extension of temporary files for problem resolution:

Alter database tempfile'/ oradata/dbs/temp01.dbf' autoextend on next 100m

Import is normal:

Import > statusJob: SYS_IMPORT_FULL_01 Operation: IMPORT Mode: FULL State: EXECUTING Bytes Processed: 843222272 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.