How To Break And Restart A DataPump Export Or Import Job

How To Break And Restart A DataPump Export Or Import Job

by

How To Break And Restart A DataPump Export Or Import Job. In this article we will discuss about How To Break And Restart A DataPump Export Or Import Job in Oracle 19c.

You can control the echo of the log output by using CTRL+C, and the expdp or impdp job will keep running in the background. If you need to interact with or monitor it, you can use Data Pump’s interactive features.

Commonly used commands in interactive mode for expdp/impdp utilities:

  1. CONTINUE_CLIENT : Switch back to the normal client, with the log output echoed to the screen again.
  2. EXIT_CLIENT : The client is closed, but the database job continues, so the operation completes as normal.
  3. KILL_JOB : Detaches all clients and kills the database job.
  4. STOP_JOB : By default, the current actions are completed, then the job is stopped. It can be resumed later. If you use the STOP_JOB=IMMEDIATE option, all actions are stopped immediately. When the job resumed, some of those actions will need to be rerun to make the action consistent.
  5. START_JOB : Restarts a stopped job.
  6. STATUS : Displays basic information about the job, including the status of the workers.

Note:-

Below I have briefly explained about commonly used commands in interactive mode for expdp utilities only, but you can use these all commands in interactive mode for impdp utilities also.

CONTINUE_CLIENT:

Switch back to the normal client, with the log output echoed to the screen again.

Check the running Export job Name and status from below SQL query:-
=====================================================

set lines 200 pages 200
col owner_name format a20
col job_name format a30
col operation format a10
col job_mode format a10
col state format a12
select owner_name, job_name, trim(operation) as operation, trim(job_mode) as job_mode, state, degree, attached_sessions, datapump_sessions from dba_datapump_jobs order by 1, 2;

OWNER_NAME           JOB_NAME                       OPERATION  JOB_MODE   STATE            DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
-------------------- ------------------------------ ---------- ---------- ------------ ---------- ----------------- -----------------
SYSTEM               SYS_EXPORT_FULL_01             EXPORT     FULL       EXECUTING             1                 1                 3



Now you can check the running datapump job log by executing CONTINUE_CLIENT command:
==============================================================

[oracle@primary ~]$
[oracle@primary ~]$ expdp system/xxxxx@orcl attach=SYS_EXPORT_FULL_01

Export: Release 19.0.0.0.0 - Production on Wed Feb 19 19:12:12 2025
Version 19.25.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Job: SYS_EXPORT_FULL_01
  Owner: SYSTEM
  Operation: EXPORT
  Creator Privs: TRUE
  GUID: 2E7FE9AE9D2C3061E063EB9CA8C06EB1
  Start Time: Wednesday, 19 February, 2025 19:11:22
  Mode: FULL
  Instance: ORCL
  Max Parallelism: 1
  Timezone: +00:00
  Timezone version: 32
  Endianness: LITTLE
  NLS character set: AL32UTF8
  NLS NCHAR character set: AL16UTF16
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        system/********@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y
     TRACE                 0
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 13
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 16,384

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Wednesday, 19 February, 2025 19:11:52
  Object status at: Wednesday, 19 February, 2025 19:12:14
  Process Name: DW00
  State: EXECUTING
  Object Schema: SYS
  Object Type: DATABASE_EXPORT/STATISTICS/MARKER
  Worker Parallelism: 1

Export>

Export>

Export> CONTINUE_CLIENT
Processing object type DATABASE_EXPORT/STATISTICS/MARKER
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/RADM_FPTM
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/SCHEMA/ON_USER_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
^C
Export>

Export>

EXIT_CLIENT:

The client is closed, but the database job continues, so the operation completes as normal.

[oracle@primary ~]$
[oracle@primary ~]$ expdp system/xxxxx@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y

Export: Release 19.0.0.0.0 - Production on Wed Feb 19 18:49:35 2025
Version 19.25.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/********@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
^C
Export>

Export> EXIT_CLIENT

[oracle@primary ~]$


Check the Export job status from below SQL query:-
===============================

set lines 200 pages 200
col owner_name format a20
col job_name format a30
col operation format a10
col job_mode format a10
col state format a12
select owner_name, job_name, trim(operation) as operation, trim(job_mode) as job_mode, state, degree, attached_sessions, datapump_sessions from dba_datapump_jobs order by 1, 2;

OWNER_NAME           JOB_NAME                       OPERATION  JOB_MODE   STATE            DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
-------------------- ------------------------------ ---------- ---------- ------------ ---------- ----------------- -----------------
SYSTEM               SYS_EXPORT_FULL_01             EXPORT     FULL       EXECUTING             1                 0                 2

SQL>


Check the export job status from 
[oracle@primary ~]$
[oracle@primary ~]$ expdp system/xxxxx@orcl attach=SYS_EXPORT_FULL_01

Export: Release 19.0.0.0.0 - Production on Wed Feb 19 18:52:23 2025
Version 19.25.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Job: SYS_EXPORT_FULL_01
  Owner: SYSTEM
  Operation: EXPORT
  Creator Privs: TRUE
  GUID: 2E7F9BE793C02B2DE063EB9CA8C0F8F6
  Start Time: Wednesday, 19 February, 2025 18:49:40
  Mode: FULL
  Instance: ORCL
  Max Parallelism: 1
  Timezone: +00:00
  Timezone version: 32
  Endianness: LITTLE
  NLS character set: AL32UTF8
  NLS NCHAR character set: AL16UTF16
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        system/********@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y
     TRACE                 0
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 8
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 106,496

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Wednesday, 19 February, 2025 18:51:28
  Object status at: Wednesday, 19 February, 2025 18:52:12
  Process Name: DW00
  State: EXECUTING

Export>

KILL_JOB:

Detaches all clients and kills the database job.

[oracle@primary ~]$ expdp system/xxxxx@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y

Export: Release 19.0.0.0.0 - Production on Tue Mar 11 15:42:05 2025
Version 19.25.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/********@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
^C
Export>

Export> STATUS

Job: SYS_EXPORT_FULL_01
  Operation: EXPORT
  Mode: FULL
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 3
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 4,096

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Tuesday, 11 March, 2025 15:42:38
  Object status at: Tuesday, 11 March, 2025 15:42:44
  Process Name: DW00
  State: EXECUTING

Export>

Export> KILL_JOB
Are you sure you wish to stop this job ([yes]/no): yes

[oracle@primary ~]$
[oracle@primary ~]$
[oracle@primary ~]$
[oracle@primary ~]$ expdp system/xxxxx@orcl attach=SYS_EXPORT_FULL_01

Export: Release 19.0.0.0.0 - Production on Tue Mar 11 15:43:33 2025
Version 19.25.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT", line 421
ORA-31638: cannot attach to job SYS_EXPORT_FULL_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 414
ORA-31632: master table "SYSTEM.SYS_EXPORT_FULL_01" not found, invalid, or inaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 406
ORA-00942: table or view does not exist
ORA-06512: at "SYS.KUPV$FT_INT", line 2847
ORA-06512: at "SYS.KUPV$FT", line 210


[oracle@primary ~]$

STOP_JOB:

By default, the current actions are completed, then the job is stopped. It can be resumed later. If you use the STOP_JOB=IMMEDIATE option, all actions are stopped immediately. When the job resumed, some of those actions will need to be rerun to make the action consistent.

[oracle@primary ~]$ expdp system/xxxxx@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y

Export: Release 19.0.0.0.0 - Production on Tue Mar 11 16:01:40 2025
Version 19.25.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/********@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
^C
Export>

Export>

Export> STATUS

Job: SYS_EXPORT_FULL_01
  Operation: EXPORT
  Mode: FULL
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 2
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 16,384

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Tuesday, 11 March, 2025 16:02:23
  Object status at: Tuesday, 11 March, 2025 16:02:24
  Process Name: DW00
  State: EXECUTING

Export>

Export>

Export> STOP_JOB=IMMEDIATE
Are you sure you wish to stop this job ([yes]/no): yes

[oracle@primary ~]$
[oracle@primary ~]$
[oracle@primary ~]$
[oracle@primary ~]$ expdp system/xxxxx@orcl attach=SYS_EXPORT_FULL_01

Export: Release 19.0.0.0.0 - Production on Tue Mar 11 16:02:40 2025
Version 19.25.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Job: SYS_EXPORT_FULL_01
  Owner: SYSTEM
  Operation: EXPORT
  Creator Privs: TRUE
  GUID: 300F983172721690E063EB13A8C0F974
  Start Time: Tuesday, 11 March, 2025 16:02:43
  Mode: FULL
  Instance: ORCL
  Max Parallelism: 1
  Timezone: +00:00
  Timezone version: 32
  Endianness: LITTLE
  NLS character set: AL32UTF8
  NLS NCHAR character set: AL16UTF16
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        system/********@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y
     TRACE                 0
  State: IDLING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 1
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 16,384

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Tuesday, 11 March, 2025 16:02:23
  Object status at: Tuesday, 11 March, 2025 16:02:24
  Process Name: DW00
  State: UNDEFINED

Export>

START_JOB:

Restarts a stopped job.

[oracle@primary ~]$ expdp system/xxxxx@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y

Export: Release 19.0.0.0.0 - Production on Tue Mar 11 16:06:54 2025
Version 19.25.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/********@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
^C
Export>

Export>

Export> STATUS

Job: SYS_EXPORT_FULL_01
  Operation: EXPORT
  Mode: FULL
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 4
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 16,384

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Tuesday, 11 March, 2025 16:07:20
  Object status at: Tuesday, 11 March, 2025 16:07:20
  Process Name: DW00
  State: EXECUTING

Export>

Export>

Export> STOP_JOB=IMMEDIATE
Are you sure you wish to stop this job ([yes]/no): yes

[oracle@primary ~]$
[oracle@primary ~]$
[oracle@primary ~]$
[oracle@primary ~]$ expdp system/xxxxx@orcl attach=SYS_EXPORT_FULL_01

Export: Release 19.0.0.0.0 - Production on Tue Mar 11 16:07:41 2025
Version 19.25.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Job: SYS_EXPORT_FULL_01
  Owner: SYSTEM
  Operation: EXPORT
  Creator Privs: TRUE
  GUID: 300FAAEBB8DA17CBE063EB13A8C0FDAA
  Start Time: Tuesday, 11 March, 2025 16:07:43
  Mode: FULL
  Instance: ORCL
  Max Parallelism: 1
  Timezone: +00:00
  Timezone version: 32
  Endianness: LITTLE
  NLS character set: AL32UTF8
  NLS NCHAR character set: AL16UTF16
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        system/********@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y
     TRACE                 0
  State: IDLING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 1
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 16,384

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Tuesday, 11 March, 2025 16:07:20
  Object status at: Tuesday, 11 March, 2025 16:07:20
  Process Name: DW00
  State: UNDEFINED

Export>

Export>

Export> START_JOB

Export>

Export> STATUS

Job: SYS_EXPORT_FULL_01
  Operation: EXPORT
  Mode: FULL
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 1
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 20,480

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Tuesday, 11 March, 2025 16:07:20
  Object status at: Tuesday, 11 March, 2025 16:07:59
  Process Name: DW00
  State: EXECUTING

Export>

Export>

Export> CONTINUE_CLIENT
Job SYS_EXPORT_FULL_01 has been reopened at Tue Mar 11 16:07:43 2025
Restarting "SYSTEM"."SYS_EXPORT_FULL_01":  system/********@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y
Processing object type DATABASE_EXPORT/STATISTICS/MARKER
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/RADM_FPTM
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/SCHEMA/ON_USER_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
^C
Export>

STATUS:

Displays basic information about the job, including the status of the workers.

[oracle@primary ~]$ expdp system/xxxxx@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y

Export: Release 19.0.0.0.0 - Production on Tue Mar 11 16:20:10 2025
Version 19.25.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/********@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
^C
Export>

Export>

Export> STATUS

Job: SYS_EXPORT_FULL_01
  Operation: EXPORT
  Mode: FULL
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 6
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 16,384

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Tuesday, 11 March, 2025 16:21:06
  Object status at: Tuesday, 11 March, 2025 16:21:07
  Process Name: DW00
  State: EXECUTING

Export>

Export>

Export> STOP_JOB=IMMEDIATE
Are you sure you wish to stop this job ([yes]/no): yes

[oracle@primary ~]$
[oracle@primary ~]$
[oracle@primary ~]$
[oracle@primary ~]$ expdp system/xxxxx@orcl attach=SYS_EXPORT_FULL_01

Export: Release 19.0.0.0.0 - Production on Tue Mar 11 16:21:38 2025
Version 19.25.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Job: SYS_EXPORT_FULL_01
  Owner: SYSTEM
  Operation: EXPORT
  Creator Privs: TRUE
  GUID: 300FDA62FE1F1B16E063EB13A8C011B9
  Start Time: Tuesday, 11 March, 2025 16:21:41
  Mode: FULL
  Instance: ORCL
  Max Parallelism: 1
  Timezone: +00:00
  Timezone version: 32
  Endianness: LITTLE
  NLS character set: AL32UTF8
  NLS NCHAR character set: AL16UTF16
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        system/********@orcl directory=exp_dir dumpfile=full_db_backup.dmp logfile=full_db_backup.log full=y
     TRACE                 0
  State: IDLING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 1
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 16,384

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Tuesday, 11 March, 2025 16:21:06
  Object status at: Tuesday, 11 March, 2025 16:21:07
  Process Name: DW00
  State: UNDEFINED

Export>

Export>

Export> STATUS

Job: SYS_EXPORT_FULL_01
  Operation: EXPORT
  Mode: FULL
  State: IDLING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 1
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 16,384

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Tuesday, 11 March, 2025 16:21:06
  Object status at: Tuesday, 11 March, 2025 16:21:07
  Process Name: DW00
  State: UNDEFINED

Export>

Export>

Export> START_JOB

Export>

Export> STATUS

Job: SYS_EXPORT_FULL_01
  Operation: EXPORT
  Mode: FULL
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 2
  Dump File: /u02/backup/full_db_backup.dmp
    bytes written: 20,480

Worker 1 Status:
  Instance ID: 1
  Instance name: ORCL
  Host name: primary.localdomain
  Object start time: Tuesday, 11 March, 2025 16:21:06
  Object status at: Tuesday, 11 March, 2025 16:22:08
  Process Name: DW00
  State: EXECUTING

Export>

I hope my written content will helped you. Your suggestions/feedback are most welcome from orakldba.com. Keep learning… Have a great day!!!
Please comment here for your any query related to above content. You can write to mail me through my Email.

Email :- orakldba@gmail.com
LinkedIn :- https://linkedin.com/in/prasantakirtaniya
Twitter :- https://twitter.com/prasantadba
Facebook Page :- https://www.facebook.com/orakldba
Website :- https://orakldba.com
ACE Profile :- https://ace.oracle.com/apex/ace/profile/prasantakirtaniya
Oracle Community :- https://community.oracle.com/customerconnect/profile/discussions/prasantakirtaniya

Leave a Comment