當(dāng)我們在生產(chǎn)環(huán)境下，不小心觸發(fā)了邏輯備份（expdp），可能會造成IO阻塞，影響生產(chǎn)業(yè)務(wù)

為伊寧等地區(qū)用戶提供了全套網(wǎng)頁設(shè)計制作服務(wù)，及伊寧網(wǎng)站建設(shè)行業(yè)解決方案。主營業(yè)務(wù)為網(wǎng)站設(shè)計、網(wǎng)站建設(shè)、伊寧網(wǎng)站設(shè)計，以傳統(tǒng)方式定制建設(shè)網(wǎng)站，并提供域名空間備案等一條龍服務(wù)，秉承以專業(yè)、用心的態(tài)度為用戶提供真誠的服務(wù)。我們深信只要達(dá)到每一位用戶的要求，就會得到認(rèn)可，從而選擇與我們長期合作。這樣，我們也可以走得更遠(yuǎn)！

那么如何終止expdp導(dǎo)出任務(wù)呢

手動執(zhí)行全庫導(dǎo)出腳本：

[oracle @server1 ~]$ ./expdp.sh

查看進(jìn)程信息：
[root @server1 ~]# ps -ef | grep expdp
oracle 3233 2842 0 04:58 pts/1 00:00:00 /bin/bash ./expdp.sh
oracle 3247 3233 0 04:58 pts/1 00:00:00 expdp sysdba’ directory=dump_file dumpfile=prod_20200803.dmp log=prod_20200803.log full=y compression=ALL
root 3254 3081 0 04:58 pts/3 00:00:00 grep expdp

[root @server1 ~]# kill -9 3247

./expdp.sh: line 13: 3247 Killed expdp \’/as sysdba\’ directory=dump_file dumpfile=$FILE_NAME log=$FILE_LOG full=y compression=ALL

數(shù)據(jù)量還是在增長：（kill發(fā)送信號量無法終止expdp導(dǎo)出任務(wù)）

[oracle @server1 backup]$ du -sh
1.2G prod
48M prod_20200803.dmp
104K prod_20200803.log
[oracle @server1 backup]$ du -sh
1.2G prod
50M prod_20200803.dmp
104K prod_20200803.log
[oracle @server1 backup]$ du -sh *
1.2G prod
54M prod_20200803.dmp
108K prod_20200803.log

查詢數(shù)據(jù)泵作業(yè)：
SQL> select job_name,state,owner_name from dba_datapump_jobs;

JOB_NAME STATE OWNER_NAME

SYS_EXPORT_FULL_01 EXECUTING SYS

[oracle @server1 ~]$ expdp \’/ as sysdba\’ attach= SYS_EXPORT_FULL_01

Export: Release 11.2.0.4.0 - Production on Mon Aug 3 05:03:13 2020

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: SYS
Operation: EXPORT
Creator Privs: TRUE
GUID: ABEC566151380D0DE05379C7A8C00DBB
Start Time: Monday, 03 August, 2020 5:02:18
Mode: FULL
Instance: prod
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND “/ **AS SYSDBA” directory=dump_file dumpfile=prod_20200803.dmp logfile=prod_20200803.log full=y reuse_dumpfiles=true
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /backup/prod_20200803.dmp
bytes written: 4,096

Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: APEX_030200
Object Name: WWV_FLOW_FL_CH_IDX
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Completed Objects: 1,466
Worker Parallelism: 1

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/prod_20200803.dmp
bytes written: 4,096

Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Type: DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
Completed Objects: 2,198
Total Objects: 2,198
Worker Parallelism: 1

停止數(shù)據(jù)泵作業(yè)：
Export> stop_job //或者 kill_job 該種方式會永久終止任務(wù)，并自動刪除產(chǎn)生的狀態(tài)表
Are you sure you wish to stop this job ([yes]/no): yes

再次查看狀態(tài)表：

SQL> select job_name,state,owner_name from dba_datapump_jobs;

JOB_NAME STATE OWNER_NAME

SYS_EXPORT_FULL_01 NOT RUNNING SYS

刪除狀態(tài)表：
SQL>drop table SYS_EXPORT_FULL_01 purge;

Table dropped.

當(dāng)狀態(tài)表過多時，采用拼接刪除語句：

SQL> select ‘drop ‘ || ‘table ‘ || job_name || ‘ purge’ from dba_datapump_jobs;