正确停止expdp导出任务

心已赠人 2022-08-06 12:29 462阅读 0赞

今天在执行导出时磁盘剩余量不够了，想提前终止expd导出任务，于是就按ctr  + c 中进入export交互界面，然后exit退出然后查看操作系统进程发现没有expdp进程了以为就是停掉了，但发现导出的dmp文件还在一直增加，其实任务并没有停止。

如下验证结果：

1.expdp执行导出操作，然后按ctr  + c  + exit 退出

\[oracle@database ~\]$expdp \\"sys/oracle as sysdba\\" schemas='(prod,tts\_fnd,tts\_cms,tts\_hr,tts\_ecm,tts\_coa,tts\_exm,tts\_htm)' dumpfile=tt.dmp logfile=tt.log directory=test  
Export: Release 11.2.0.4.0 - Production on Mon Jan 26 10:27:01 2015  
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  
Starting "SYS"."SYS\_EXPORT\_SCHEMA\_02":  "sys/\*\*\*\*\*\*\*\* AS SYSDBA" schemas=(prod,tts\_fnd,tts\_cms,tts\_hr,tts\_ecm,tts\_coa,tts\_exm,tts\_htm) dumpfile=tt.dmp logfile=tt.log directory=test   
Estimate in progress using BLOCKS method...  
Processing object type SCHEMA\_EXPORT/TABLE/TABLE\_DATA  
Total estimation using BLOCKS method: 23.98 GB  
Processing object type SCHEMA\_EXPORT/USER  
Processing object type SCHEMA\_EXPORT/SYSTEM\_GRANT  
Processing object type SCHEMA\_EXPORT/ROLE\_GRANT  
Processing object type SCHEMA\_EXPORT/DEFAULT\_ROLE  
Processing object type SCHEMA\_EXPORT/TABLESPACE\_QUOTA  
Processing object type SCHEMA\_EXPORT/PRE\_SCHEMA/PROCACT\_SCHEMA  
Processing object type SCHEMA\_EXPORT/SYNONYM/SYNONYM  
Processing object type SCHEMA\_EXPORT/TYPE/TYPE\_SPEC  
Processing object type SCHEMA\_EXPORT/SEQUENCE/SEQUENCE  
Processing object type SCHEMA\_EXPORT/TABLE/TABLE  
Processing object type SCHEMA\_EXPORT/TABLE/GRANT/OWNER\_GRANT/OBJECT\_GRANT  
Processing object type SCHEMA\_EXPORT/TABLE/COMMENT  
Processing object type SCHEMA\_EXPORT/PACKAGE/PACKAGE\_SPEC  
Processing object type SCHEMA\_EXPORT/FUNCTION/FUNCTION  
Processing object type SCHEMA\_EXPORT/PROCEDURE/PROCEDURE  
Processing object type SCHEMA\_EXPORT/PACKAGE/COMPILE\_PACKAGE/PACKAGE\_SPEC/ALTER\_PACKAGE\_SPEC  
Processing object type SCHEMA\_EXPORT/FUNCTION/ALTER\_FUNCTION  
Processing object type SCHEMA\_EXPORT/PROCEDURE/ALTER\_PROCEDURE  
Processing object type SCHEMA\_EXPORT/TABLE/INDEX/INDEX  
^C  
Export> exit     \----退出

\[root@database backup\]\# ps -ef |grep expdp     ----查看进程已经不存在了  
root     17581 17434  0 10:28 pts/1    00:00:00 grep expdp

2. 发现磁盘空间一直在使用，看出导出文件dmp 一直还在增加，如下

\[root@database backup\]\# du -sm tt.dmp   
1       tt.dmp  
\[root@database backup\]\# du -sm tt.dmp   
3       tt.dmp  
\[root@database backup\]\# ps -ef |grep expdp  
root     17581 17434  0 10:28 pts/1    00:00:00 grep expdp  
\[root@database backup\]\# du -sm tt.dmp   
13      tt.dmp  
\[root@database backup\]\#   
\[root@database backup\]\# du -sm tt.dmp   
14      tt.dmp  
\[root@database backup\]\# du -sm tt.dmp   
1767    tt.dmp  
\[root@database backup\]\# du -sm tt.dmp   
12207   tt.dmp

\----导出任务其实是没有停掉

3.查看视图dba\_datapump\_jobs

select job\_name,state from dba\_datapump\_jobs;

![Center][]

发现任务确认还在执行

4.正确停止expdp导出任务使用stop\_job

\[oracle@database ~\]$ expdp \\"sys/oracle as sysdba\\" attach=SYS\_EXPORT\_SCHEMA\_02  
Export: Release 11.2.0.4.0 - Production on Mon Jan 26 10:31:42 2015  
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\_SCHEMA\_02  
  Owner: SYS                              
  Operation: EXPORT                           
  Creator Privs: TRUE                             
  GUID: 0D85DF9D2F014494E053A80013AC483D  
  Start Time: Monday, 26 January, 2015 10:27:03  
  Mode: SCHEMA                           
  Instance: orcl  
  Max Parallelism: 1  
  EXPORT Job Parameters:  
  Parameter Name      Parameter Value:  
     CLIENT\_COMMAND        "sys/\*\*\*\*\*\*\*\* AS SYSDBA" schemas=(prod,tts\_fnd,tts\_cms,tts\_hr,tts\_ecm,tts\_coa,tts\_exm,tts\_htm) dumpfile=tt.dmp logfile=tt.log directory=test   
  State: EXECUTING                        
  Bytes Processed: 17,595,108,512  
  Percent Done: 81  
  Current Parallelism: 1  
  Job Error Count: 0  
  Dump File: /oracle/backup/tt.dmp  
    bytes written: 17,610,469,376    
Worker 1 Status:  
  Process Name: DW00  
  State: EXECUTING                        
  Object Schema: TTS\_EXM  
  Object Name: EXM\_PERSON\_ITEMS  
  Object Type: SCHEMA\_EXPORT/TABLE/TABLE\_DATA  
  Completed Objects: 80  
  Total Objects: 1,400  
  Worker Parallelism: 1  
Export> stop\_job=immediate   
Are you sure you wish to stop this job (\[yes\]/no): yes     
\[oracle@database ~\]$

在此查看视图dba\_datapump\_jobs

![Center 1][]

发现SYS\_EXPORT\_SCHEMA\_02已经是not runing状态了

[Center]: /images/20220806/f6b096c78f0546bb9571ca9339a2990d.png
[Center 1]: /images/20220806/16feaeca8c294061906f3b41cc5ee038.png