oracle数据库expdp/impdp操作的终止

2018-01-18 11:01:56来源:oschina作者:tututu_jiang人点击

分享

执行expdp/impdp操作时,如果中途发现执行错误或者其他原因需要取消时,不能直接通过ctrl+c或者关闭操作窗口进行取消。使用以上操作取消后,expdp/impdp进程仍然在运行中。


[oracle@rac1 ~]$ expdp userid='/ as sysdba' dumpfile=full.dmp logfile=full.log directory=dump_dir full=y


Export: Release 11.2.0.4.0 - Production on Fri Jan 12 18:00:08 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, Real Application Clusters, Automatic Storage Management, OLAP,


Data Mining and Real Application Testing options


Starting "SYS"."SYS_EXPORT_FULL_01": userid="/******** AS SYSDBA" dumpfile=full.dmp logfile=full.log directory=dump_dir full=y


Estimate in progress using BLOCKS method...


Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA


Total estimation using BLOCKS method: 370.6 MB


Processing object type DATABASE_EXPORT/TABLESPACE


Processing object type DATABASE_EXPORT/PROFILE


Processing object type DATABASE_EXPORT/SYS_USER/USER


^C


[oracle@rac1 ~]$ du -sk *


956 full.dmp


4 full.log


[oracle@rac1 ~]$ du -sk *


1040 full.dmp


4 full.log


我们发现dmp文件一直在增长,此时如果需要停止该JOB。


expdp userid='/ as sysdba' attach=SYS_EXPORT_FULL_01


Export> stop_job


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


[oracle@rac1 ~]$


[oracle@rac1 ~]$ du -sk *


25260 full.dmp


8 full.log


[oracle@rac1 ~]$ du -sk *


25260 full.dmp


8 full.log


正常停止后dump文件不再增长。



最新文章

123

最新摄影

闪念基因

微信扫一扫

第七城市微信公众平台