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