数据泵作业执行过程中可以使用Ctrl+C组合键使其暂停，进入用户交互模式。注意和普通的OS操作不一样的地方是，Ctrl+C不会cancel正在执行的作业，而是使其数据泵进入交互模式。

下面的例子可以演示其效果

[oracle@snow ~]$ expdp dp/dp@pdb1 directory=dp_dir dumpfile=full_pdb1.dmp logfile=full_pdb1.log full=y reuse_dumpfiles=y

Export: Release 12.1.0.1.0 - Production on Mon Feb 9 20:59:01 2015

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Starting "DP"."SYS_EXPORT_FULL_08": dp/********@pdb1 directory=dp_dir dumpfile=full_pdb1.dmp logfile=full_pdb1.log full=y reuse_dumpfiles=y

Estimate in progress using BLOCKS method...

Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA

Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA

...省区部分输出

Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM

^C <==此处输入Ctrl+c组合键进入交互模式

Export> stop_job <==此处输出stop_job停止当前作业

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

如果想要继续刚才的作业SYS_EXPORT_FULL_08，使用下面的命令

[oracle@snow ~]$ expdp dp/dp@pdb1 attach=SYS_EXPORT_FULL_08

Export: Release 12.1.0.1.0 - Production on Mon Feb 9 20:59:50 2015

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Job: SYS_EXPORT_FULL_08

Owner: DP

Operation: EXPORT

Creator Privs: TRUE

GUID: 0EB33B193924505EE0530CE410AC082E

Start Time: Monday, 09 February, 2015 20:59:53

Mode: FULL

Instance: cdb

Max Parallelism: 1

Timezone: -07:00

Timezone version: 18

Endianness: LITTLE

NLS character set: AL32UTF8

NLS NCHAR character set: AL16UTF16

EXPORT Job Parameters:

Parameter Name Parameter Value:

CLIENT_COMMAND dp/********@pdb1 directory=dp_dir dumpfile=full_pdb1.dmp logfile=full_pdb1.log full=y reuse_dumpfiles=y

State: IDLING

Bytes Processed: 0

Current Parallelism: 1

Job Error Count: 0

Dump File: /home/oracle/full_pdb1.dmp

bytes written: 4,096

Worker 1 Status:

Instance ID: 1

Instance name: cdb

Host name: snow.oracle.com

State: UNDEFINED

Export> start_job <==此处输入start_job继续SYS_EXPORT_FULL_08作业

Export> continue_client <==此处输入continue_client退出交互模式，返回屏幕输出模式继续作业

Job SYS_EXPORT_FULL_08 has been reopened at Mon Feb 9 20:59:53 2015

Restarting "DP"."SYS_EXPORT_FULL_08": dp/********@pdb1 directory=dp_dir dumpfile=full_pdb1.dmp logfile=full_pdb1.log full=y reuse_dumpfiles=y

Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE

Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER

Processing object type DATABASE_EXPORT/SCHEMA/XMLSCHEMA/XMLSCHEMA

Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE

..省去部分输出

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA

Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE

Processing object type DATABASE_EXPORT/AUDIT

Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER

. . exported "SYS"."KU$_USER_MAPPING_VIEW" 6.164 KB 45 rows

. . exported "ORDDATA"."ORDDCM_DOCS" 252.9 KB 9 rows

. . exported "SYS"."AUD$" 22.81 KB 2 rows

. . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5.734 KB 8 rows

. . exported "LBACSYS"."OLS$DIP_EVENTS" 5.515 KB 2 rows

..省去部分输出

. . exported "PM"."ONLINE_MEDIA" 7.856 MB 9 rows

. . exported "SH"."CUSTOMERS" 10.27 MB 55500 rows

. . exported "SH"."COSTS":"COSTS_Q1_1998" 139.6 KB 4411 rows

. . exported "SH"."COSTS":"COSTS_Q1_1999" 183.7 KB 5884 rows

. . exported "SH"."COSTS":"COSTS_Q1_2000" 120.7 KB 3772 rows

..省去部分输出

. . exported "SH"."SALES":"SALES_Q4_2002" 0 KB 0 rows

. . exported "SH"."SALES":"SALES_Q4_2003" 0 KB 0 rows

Master table "DP"."SYS_EXPORT_FULL_08" successfully loaded/unloaded

******************************************************************************

Dump file set for DP.SYS_EXPORT_FULL_08 is:

/home/oracle/full_pdb1.dmp

Job "DP"."SYS_EXPORT_FULL_08" completed with 1 error(s) at Mon Feb 9 21:01:38 2015 elapsed 0 00:01:46

导出作业完成！

常用导入/导出作业交互式命令如下

命令	描述
ADD_FILE (expdp独有)	向导出数据泵文件集合添加文件
CONTINUE_CLIENT	返回事件记录模式
EXIT_CLIENT	退出客户端会话并返回OS命令行界面，保持作业运行
FILESIZE (expdp独有)	定义数据泵文件尺寸
HELP	帮助
KILL_JOB	终止作业，不能在使用其它方式继续。有别于stop_job
PARALLEL	调整并行度，根据服务器压力提高或者降低
REUSE_DUMPFILES (expdp独有)	覆盖已经存在的数据泵文件
START_JOB	重启当前作业，通常配合stop_job使用
STATUS	显示当前作业的状态
STOP_JOB[=IMMEDIATE]	停止正在运行的作业（将来可以使用expdp userid attach=作业号配合交互式命令start_job来继续该作业）

全文完

ITPub博客

12c 数据泵命令行交互模式

最新文章