查看expdp或impdp job状态并中止

最新推荐文章于 2024-07-24 04:28:17 发布

夜光小兔纸

最新推荐文章于 2024-07-24 04:28:17 发布

阅读量1.1k

点赞数

分类专栏：数据库 Oracle 文章标签： oracle 数据库

本文链接：https://blog.csdn.net/Ruishine/article/details/118571379

版权

数据库同时被 2 个专栏收录

209 篇文章 27 订阅

订阅专栏

Oracle

179 篇文章 17 订阅

订阅专栏

这篇博客介绍了如何在Oracle数据库中使用Datapump进行expdp和impdp操作时，查看作业状态以及如何中断作业。通过SQL查询获取job_name，然后使用expdp或impdp命令附加上作业名来检查状态。如果需要停止或杀掉作业，可以使用stop_job和kill_job命令，并确认操作。示例展示了具体的操作流程。

摘要由CSDN通过智能技术生成

expdp状态查看及中断方法

主要步骤

--查看job名称
SQL> select job_name from dba_datapump_jobs;

JOB_NAME
--------------------------------------------------------------------------------
RUI20210707_JOB

--查看job状态
$ expdp rui/XXX attach=RUI20210707_JOB

--停止job
Import> stop_job
Are you sure you wish to stop this job ([yes]/no): yes  --提问是否停止job，输入yes

--杀掉job
Import> kill_job
Are you sure you wish to stop this job ([yes]/no): yes  --提问是否杀掉job，输入yes

impdp状态查看及中断方法

主要步骤

--查看job名称
SQL> select job_name from dba_datapump_jobs;

JOB_NAME
--------------------------------------------------------------------------------
RUI20210707_JOB


-- 查看job状态
$ impdp rui/XXX attach=RUI20210707_JOB

--停止job
Import> stop_job
Are you sure you wish to stop this job ([yes]/no): yes  --提问是否停止job，输入yes

--杀掉job
Import> kill_job
Are you sure you wish to stop this job ([yes]/no): yes  --提问是否杀掉job，输入yes

实例展示

为了更好地理解，下面贴出一次实际操作的过程记录，如下：

# su - oracle
Last login: Wed Jul  7 20:01:48 CST 2021 on pts/1

$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 8 13:06:50 2021

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select job_name from dba_datapump_jobs;

JOB_NAME
--------------------------------------------------------------------------------
RUI20210707_JOB

SQL> exit;
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

$ impdp rui/XXX attach=RUI20210707_JOB

Import: Release 12.1.0.2.0 - Production on Thu Jul 8 13:16:09 2021

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Job: RUI20210707_JOB
  Owner: RUI
  Operation: IMPORT
  Creator Privs: TRUE
  GUID: C6885074B640111EE055526B8D43F35F
  Start Time: Wednesday, 07 July, 2021 20:02:38
  Mode: FULL
  Instance: orcl
  Max Parallelism: 1
  Timezone: +00:00
  Export timezone: +08:00
  Timezone version: 18
  Endianness: LITTLE
  NLS character set: AL32UTF8
  NLS NCHAR character set: AL16UTF16
  Export NLS NCHAR character set: UTF8
  EXPORT Job Parameters:
 
 ......  --此处省略部分内容

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

[oracle@pcplmdevdb ~]$  impdp trui/oracle123 attach=RUI20210707_JOB

Import: Release 12.1.0.2.0 - Production on Thu Jul 8 13:19:46 2021

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Job: RUI20210707_JOB
  Owner: RUI
  Operation: IMPORT
  Creator Privs: TRUE
  GUID: C6885074B640111EE055526B8D43F35F
  Start Time: Wednesday, 07 July, 2021 20:02:38
  Mode: FULL
  Instance: orcl
  Max Parallelism: 1
  Timezone: +00:00
  Export timezone: +08:00
  Timezone version: 18
  Endianness: LITTLE
  NLS character set: AL32UTF8
  NLS NCHAR character set: AL16UTF16
  Export NLS NCHAR character set: UTF8
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
 
 ......  --此处省略部分内容

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

[oracle@pcplmdevdb ~]$