指定文件大小乘以文件个数小于实际数据量大小,导出报错停止,仅仅是停止;
ls -lh /u01/backup -rw-r--r--. 1 oracle asmadmin 1.8K Jun 2 17:18 export.log -rw-r--r--. 1 oracle asmadmin 1.5K Jun 2 18:21 exportt01.log -rw-r-----. 1 oracle asmadmin 10M Jun 2 18:21 file02.dmp -rw-r-----. 1 oracle asmadmin 10M Jun 2 18:21 file03.dmp -rw-r-----. 1 oracle asmadmin 10M Jun 2 18:21 file04.dmp -rw-r-----. 1 oracle asmadmin 10M Jun 2 18:21 size_each_sywu.dump此时查看数据库,发现一张于job_name名称相同的表EXPORTTB_BYSIZE,表中记录了导数时的信息;查询job的状态为:NOT RUNING;
select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- EXPORTTB_BYSIZE TABLE TB01 TABLE TB02 TABLE T_EXCE TABLE select job_name,state from dba_datapump_jobs; JOB_NAME STATE ------------------------------ ------------------------------ EXPORTTB_BYSIZE NOT RUNNING继续完成导数可以通过添加dump文件或使用系统默认的文件
expdp userid='ops$sywu/sywu' attach=EXPORTTB_BYSIZE Export: Release 11.2.0.3.0 - Production on Tue Jun 2 22:28:37 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Job: EXPORTTB_BYSIZE Owner: OPS$SYWU Operation: EXPORT Creator Privs: FALSE GUID: 178798A215814641E053FE1813ACD41C Start Time: Tuesday, 02 June, 2015 22:28:38 Mode: SCHEMA Instance: sydb Max Parallelism: 1 EXPORT Job Parameters: Parameter Name Parameter Value: CLIENT_COMMAND userid=ops$sywu/******** job_name=exporttb_bysize SCHEMAS=ops$sywu filesize=10485760 dumpfile=size_each_sywu.dump,file02.dmp,file03.dmp,file04.dmp directory=pump_dir logfile=exportt01.log State: IDLING Bytes Processed: 0 Current Parallelism: 1 Job Error Count: 0 Dump File: /u01/backup/size_each_sywu.dump size: 10,485,760 bytes written: 10,485,760 Dump File: /u01/backup/file02.dmp size: 10,485,760 bytes written: 10,485,760 Dump File: /u01/backup/file03.dmp size: 10,485,760 bytes written: 10,485,760 Dump File: /u01/backup/file04.dmp size: 10,485,760 bytes written: 10,485,760 Worker 1 Status: Process Name: DW00 State: UNDEFINED Object Schema: OPS$SYWU Object Name: TB01 Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA Completed Objects: 1 Total Objects: 3 Completed Bytes: 41,844,736 Percent Done: 45 Worker Parallelism: 1 Export> add_file=file05.dmp Export> start_job