Resume the canceled expdp backup
expdp test/test full=y job_name=EXP_FULL directory=TEST_EXP dumpfile=TEST_EXP.dmp
SQL> SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs;
TEST EXP_FULL EXPORT FULL EXECUTING
while the job is running i have closed the session.
I created a new session and fired the below commands
SQL> SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs;
TEST EXP_FULL EXPORT FULL EXECUTING
[oracle@DWH_UAT_DB2:/uatrmanbkp1/TEST_EXP]$expdp test/test ATTACH=EXP_FULL
Export: Release 11.2.0.3.0 – Production on Mon Jul 21 17:38:14 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Job: EXP_FULL
Owner: TEST
Operation: EXPORT
Creator Privs: TRUE
GUID: FEB3EECCF504009AE0430A96074DD92E
Start Time: Monday, 21 July, 2014 17:36:14
Mode: FULL
Instance: deveod
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND test/******** full=y job_name=EXP_FULL directory=TEST_EXP dumpfile=TEST_EXP.dmp
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /uatrmanbkp1/TEST_EXP/TEST_EXP.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: BDSDEV
Object Name: ISIN_OTH_DTL
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 2,960
Worker Parallelism: 1
Export> continue — here i have given the continue command so the job started again
Total estimation using BLOCKS method: 110.3 GB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/PROXY
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
I pressed the ctrl+c again
Export> continue
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/GRANT/PROCOBJ_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
To stop this job press “Ctrl + c” and give any of the below command
1) STOP — This will stop the job , we can restart the job — command : STOP_JOB
2) KILL — This will kill the job and delete the export file (.dmp) and we can not start the job again
— command : KILL_JOB
Export> KILL_JOB
Are you sure you wish to stop this job ([yes]/no): Yes
This has deleted the .dmp file and stopped the expdp.
Viswamitra's blog 