oracle导数进度查询

1、查询DBA_DATAPUMP_JOBS表获取job_name信息

SELECT * FROM DBA_DATAPUMP_JOBS;

 

2、编辑par文件

impdp_attach.par
userid="/ as sysdba"
ATTACH=<job_name>

 

3、执行导数命令，进入查看

impdp parfile=impdp_attach.par

 

命令使用：

Import> help
------------------------------------------------------------------------------

The following commands are valid while in interactive mode.
Note: abbreviations are allowed.

CONTINUE_CLIENT
Return to logging mode. Job will be restarted if idle.

EXIT_CLIENT
Quit client session and leave job running.

HELP
Summarize interactive commands.

KILL_JOB
Detach and delete job.

PARALLEL
Change the number of active workers for current job.

START_JOB
Start or resume current job.
Valid keywords are: SKIP_CURRENT.

STATUS
Frequency (secs) job status is to be monitored where
the default [0] will show new status when available.

STOP_JOB
Orderly shutdown of job execution and exits the client.
Valid keywords are: IMMEDIATE.

STOP_WORKER
Stops a hung or stuck worker.

TRACE
Set trace/debug flags for the current job.

 

查看状态

Import> status

Job: SYS_IMPORT_FULL_02
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 38,295,206,968
Percent Done: 12
Current Parallelism: 4
Job Error Count: 0
Job heartbeat: 1
Dump File: /oracle/dump/exp_DATA__%u.dmp
Dump File: /oracle/dump/exp_DATA_01.dmp


Worker 1 Status:
Instance ID: 1
Instance name: orcl
Host name: hostname
Access method: external_table
Object start time: Sunday, 28 April, 2024 20:28:30
Object status at: Sunday, 28 April, 2024 20:28:30
Process Name: DW00
State: WORK WAITING

Worker 2 Status:
Instance ID: 1
Instance name: orcl
Host name: hostname
Object start time: Sunday, 28 April, 2024 19:29:37
Object status at: Sunday, 28 April, 2024 19:29:37
Process Name: DW01
State: EXECUTING
Object Schema: USER
Object Name: SA_DB_GDNPNONETINFO
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 115
Completed Rows: 5,530,385
Completed Bytes: 100,175,024
Percent Done: 81
Worker Parallelism: 1

 

停止卡住的WORKER

Import>STOP_WORKER=2

Import>