结束oracle import,Oracle 结束 imp/exp 和 expdp/impdp 进程的正确方法

在之前写的博客里讲过Oracle 10g 开始引入的数据泵功能：

Oracle 10g Data Pump Expdp/Impdp 详解

https://www.cndba.cn/Dave/article/1278https://www.cndba.cn/dave/article/2844

https://www.cndba.cn/dave/article/2844

在文章里提到， 数据泵(expdp/impdp)实际的工作是在数据库服务端后台以JOB形式执行，也就是说我们执行数据泵命令实际上在数据库后台创建了一个JOB。 因此，加入我们想终止数据泵的工作，就不能向传统的导出导入命令(exp/imp), 直接kill进程就可以了。 要想kill 数据泵命令，必须连到后台进行操作。 https://www.cndba.cn/dave/article/2844

一般来说，expdp/impdp 命令有一个参数：job_name=cndba, 如果没有指定这个参数，那么就需要通过DBA_DATAPUMP_JOBS试图来查询。

SQL> select * from dba_datapump_jobs;

OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS

------------------------------ ---------- ----------------- -----------------

SYSTEM SYS_EXPORT_FULL_01 EXPORT FULL UNDEFINED 1 1 2

另外expdp/impdp在执行时，有一个交互模式，在执行命令窗口，按Ctrl+C就可以进入交互模式，在交互模式，可以执行kill_job命令来结束expdp/impdp命令，否则他还会在后头继续执行。

[dave@www.cndba.cn ~]$ expdp system/oracle directory=DUMP_DIR full=y

Export: Release 11.2.0.4.0 - Production on Fri Jun 8 16:24:14 2018

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** directory=DUMP_DIR full=y

Estimate in progress using BLOCKS method...

^C

Export> status

Job: SYS_EXPORT_FULL_01

Operation: EXPORT

Mode: FULL

State: EXECUTING

Bytes Processed: 0

Current Parallelism: 1

Job Error Count: 0

Dump File: /backup/expdat.dmp

bytes written: 4,096

Worker 1 Status:

Process Name: DW00

State: EXECUTING

Export> kill_job

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

[dave@www.cndba.cn ~]$

如果当前执行的终端窗口已经关闭了，还可以通过expdp/impdp的ATTACH来连接到之前的JOB。

https://www.cndba.cn/dave/article/2844https://www.cndba.cn/dave/article/2844

[dave@www.cndba.cn ~]$ expdp system/oracle attach=SYS_EXPORT_FULL_01

Export: Release 11.2.0.4.0 - Production on Fri Jun 8 16:28:06 2018

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Job: SYS_EXPORT_FULL_01

Owner: SYSTEM

Operation: EXPORT

Creator Privs: TRUE

GUID: 6E1E2C8095271134E0535601A8C0D110

Start Time: Friday, 08 June, 2018 16:27:45

Mode: FULL

Instance: cndba

Max Parallelism: 1

EXPORT Job Parameters:

Parameter Name Parameter Value:

CLIENT_COMMAND system/******** directory=DUMP_DIR full=y

State: EXECUTING

Bytes Processed: 0

Current Parallelism: 1

Job Error Count: 0

Dump File: /backup/expdat.dmp

bytes written: 4,096

Worker 1 Status:

Process Name: DW00

State: EXECUTING

Object Name: +*

Object Type: DATABASE_EXPORT/TRUSTED_DB_LINK

Completed Objects: 1

Total Objects: 1

Worker Parallelism: 1

Export> kill_job

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

[dave@www.cndba.cn ~]$

Expdp/impdp命令的更多交互命令可以通过help进行查看，如下：https://www.cndba.cn/dave/article/2844https://www.cndba.cn/dave/article/2844

Export> help

------------------------------------------------------------------------------

The following commands are valid while in interactive mode.

Note: abbreviations are allowed.

ADD_FILE

Add dumpfile to dumpfile set.

CONTINUE_CLIENT

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

EXIT_CLIENT

Quit client session and leave job running.

FILESIZE

Default filesize (bytes) for subsequent ADD_FILE commands.

HELP

Summarize interactive commands.

KILL_JOB

Detach and delete job.

PARALLEL

Change the number of active workers for current job.

REUSE_DUMPFILES

Overwrite destination dump file if it exists [N].

START_JOB

Start or resume current job.

Valid keyword values 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 keyword values are: IMMEDIATE.

版权声明：本文为博主原创文章，未经博主允许不得转载。