ATTACH :
The ATTACH parameter used to attach the interrupted job and status of datapump operation.
- It has the name of export or import job (default name will be SYS_EXPORT_XXXX_01, where XXXX can be FULL or SCHEMA or TABLE).
- Whenever Data Pump export or import is running, Oracle will create a table with the JOB_NAME and will be deleted once the job is done. From this table, Oracle will find out how much job has been completed and from where to continue etc.
Attaching to and Restarting a Stopped Job :-
STATUS of attach job:
expdp system/oracle attach=JOB_NAME
The below job is in idle stage.
[oracle@18c ~]$ expdp system/oracle attach=SYS_EXPORT_SCHEMA_02 Export: Release 18.0.0.0.0 - Production on Mon Aug 20 22:19:02 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Job: SYS_EXPORT_SCHEMA_02 Owner: SYSTEM Operation: EXPORT Creator Privs: TRUE GUID: 73E179EA47021DBEE0536801A8C01560 Start Time: Monday, 20 August, 2018 22:19:03 Mode: SCHEMA Instance: prod18c Max Parallelism: 1 Timezone: +00:00 Timezone version: 31 Endianness: LITTLE NLS character set: AL32UTF8 NLS NCHAR character set: AL16UTF16 EXPORT Job Parameters: Parameter Name Parameter Value: CLIENT_COMMAND system/******** directory=DATA_PUMP_DIR dumpfile=emp_prod18c.dmp logfile=emp_prod18c.log TRACE 0 State: IDLING Bytes Processed: 0 Current Parallelism: 1 Job Error Count: 0 Job heartbeat: 4 Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp bytes written: 28,672 Worker 1 Status: Instance ID: 1 Instance name: prod18c Host name: 18c.localdomain.com Object start time: Monday, 20 August, 2018 22:04:09 Object status at: Monday, 20 August, 2018 22:04:13 Process Name: DW00 State: UNDEFINED
The above job was stopped,we need to restart the job.
Export> START_JOB
Export> STATUS
Job: SYS_EXPORT_SCHEMA_02
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 32,768
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Monday, 20 August, 2018 22:04:09
Object status at: Monday, 20 August, 2018 22:21:56
Process Name: DW00
State: EXECUTING
Monitoring datapump jobs :
select * from dba_datapump_jobs;
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
