Sunday 14 June 2015


RESTARTING OF STOPPED EXPDP JOB


My Data Pump Expdp job stopped automatically due to space crunch:

Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
Processing object type SCHEMA_EXPORT/JAVA_CLASS/JAVA_CLASS
Processing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION
Processing object type SCHEMA_EXPORT/TABLE/MATERIALIZED_VIEW_LOG
ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
Job "TOSENDALERT"."EXP_NUCLEUS_JOB" stopped due to fatal error at 08:30:11
^C

I've followed below mentioned steps to reattach the job and restart it:

Step 1:- Attach the stopped expdp job:

expdp TOSENDALERT ATTACH=EXP_NUCLEUS_JOB;

Server Screen shot:
[oracle@MYINSLGGNSBIEDB4 EXPDP_MIGNEW]$ expdp TOSENDALERT ATTACH=EXP_NUCLEUS_JOB;
Export: Release 11.2.0.3.0 - Production on Fri May 29 09:25:42 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Job: EXP_NUCLEUS_JOB
  Owner: TOSENDALERT
  Operation: EXPORT
  Creator Privs: TRUE
  GUID: 1730A6303DAA2A02E0530C488F039901
  Start Time: Friday, 29 May, 2015 9:26:14
  Mode: SCHEMA
  Instance: wcpmig1
  Max Parallelism: 4
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        tosendalert/******** parfile=exp_NUCLEUS.par
  State: IDLING
  Bytes Processed: 0
  Current Parallelism: 4
  Job Error Count: 0
  Dump File: /exportdump/EXPDP_MIGNEW/exp_NUCLEUS.dmp
    bytes written: 5,677,056
Worker 1 Status:
  Process Name: DW00
  State: UNDEFINED
Worker 2 Status:
  Process Name: DW01
  State: UNDEFINED
Worker 3 Status:
  Process Name: DW02
  State: UNDEFINED
  Object Schema: NUCLEUS
  Object Name: NAPS_APP_M
  Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
  Completed Objects: 1
  Total Objects: 928
  Worker Parallelism: 1
Worker 4 Status:
  Process Name: DW03
  State: UNDEFINED


Step-2: Start the stopped job

In Export prompt write START_JOB and then CONTINUE_CLIENT

Export> START_JOB
Export> CONTINUE_CLIENT

Server Screen shot:
Export> START_JOB
Export> CONTINUE_CLIENT
Job EXP_NUCLEUS_JOB has been reopened at Friday, 29 May, 2015 9:26
Restarting "TOSENDALERT"."EXP_NUCLEUS_JOB":  tosendalert/******** parfile=exp_NUCLEUS.par

No comments:

Post a Comment