START_JOB :
It will restart the current job.START_JOB=SKIP_CURRENT will start the job after skipping any action which was in progress when job was stopped.
STATUS of attach job:
[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
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
