Resuming failed or stopped Data Pump Import execution

Resuming failed or stopped Data Pump Import execution

When datapump import stops or fails, may be because putty was closed by mistake or Job got stopped due some db errors then we can resume datapump as below.

1.Identify the datapump import Job which you had started as below.

SYS@TESTDB1 AS SYSDBA 13-FEB-12> select * from dba_datapump_jobs;

OWNER_NAME                     JOB_NAME                       OPERATION                      JOB_MODE                       STATE                              DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ----------------- -----------------
SYSTEM                         SYS_IMPORT_SCHEMA_01           IMPORT                         SCHEMA                         EXECUTING                               8                 0          9

SYS@TESTDB1 AS SYSDBA 13-FEB-12> exit

2.Then resume this import by attaching the Job and then enter continue as below.

$ impdp system/manager attach=SYS_IMPORT_SCHEMA_01

Import: Release 11.2.0.2.0 - Production on Mon Feb 13 00:15:40 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Job: SYS_IMPORT_SCHEMA_01
  Owner: SYSTEM
  Operation: IMPORT
  Creator Privs: TRUE
  GUID: B8D498476B797D54E040F10A07255A96
  Start Time: Sunday, 12 February, 2012 23:40:40
  Mode: SCHEMA
  Instance: TESTDB1
  Max Parallelism: 8
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        system/******** dumpfile=expdp_TESTDB_20121302.dmp logfile=expdp_TESTDB_20121302.log directory=dump_dir1 schemas=user parallel=8
  IMPORT Job Parameters:
     CLIENT_COMMAND        system/******** dumpfile=expdp_TESTDB_20121302.dmp logfile=impdp_expdp_TESTDB_TESTDB1_20121302.log directory=dump_dir schemas=user remap_schema=user:user_gr parallel=8
  State: EXECUTING
  Bytes Processed: 10,378,558,440
  Percent Done: 99
  Current Parallelism: 8
  Job Error Count: 0
  Dump File: /bi_oradata_01/dumps/expdp_TESTDB_20121302.dmp

Worker 1 Status:
  Process Name: DW00
  State: EXECUTING
  Object Schema: USER_GR
  Object Name: Q1_USZIP54004_SDX
  Object Type: SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
  Completed Objects: 21
  Worker Parallelism: 8

Worker 2 Status:
  Process Name: DW01
  State: WORK WAITING

Worker 3 Status:
  Process Name: DW02
  State: WORK WAITING

Worker 4 Status:
  Process Name: DW03
  State: WORK WAITING

Worker 5 Status:
  Process Name: DW04
  State: WORK WAITING

Worker 6 Status:
  Process Name: DW05
  State: WORK WAITING

Worker 7 Status:
  Process Name: DW06
  State: WORK WAITING

Worker 8 Status:
  Process Name: DW07
  State: WORK WAITING


Import> continue