ITPub博客

首页 > Linux操作系统 > Linux操作系统 > expdp的停止与重启动

expdp的停止与重启动

原创 Linux操作系统 作者:rongshiyuan 时间:2012-05-31 19:36:03 0 删除 编辑

expdp的停止与重启动

http://space.itpub.net/271283/viewspace-471138

[oracle@rhel131 ~]$ expdp l5m/l5m directory=dpdata dumpfile=full.dmp full=y job_name=expfull

Export: Release 10.2.0.1.0 - Production on Wednesday, 15 October, 2008 2:23:47

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "L5M"."EXPFULL": l5m/******** directory=dpdata dumpfile=full.dmp full=y job_name=expfull
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

这里按^C退出交互模式,进入命令行模式,用status看看状态

Export> status

Job: EXPFULL
Operation: EXPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /home/oracle/full.dmp
bytes written: 4,096

Worker 1 Status:
State: EXECUTING


Export> status

Job: EXPFULL
Operation: EXPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /home/oracle/full.dmp
bytes written: 4,096

Worker 1 Status:
State: EXECUTING
Object Schema: SYSMAN
Object Name: MGMT_DB_HDM_METRIC_HELPER
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 480
Worker Parallelism: 1

停止该任务
Export> stop_job
Are you sure you wish to stop this job ([yes]/no): y


进入数据库,可以看到为执行导出任务所创建的Mater Table表

[oracle@rhel131 ~]$ sqlplus l5m/l5m

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 15 02:29:31 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select owner,TABLE_NAME,STATUS From dba_tables where table_name='EXPFULL';

OWNER TABLE_NAME STATUS
------------------------------ ------------------------------ --------
L5M EXPFULL VALID

接下来可以通过命令再次连接到这个任务

[oracle@rhel131 ~]$ expdp l5m/l5m attach=expfull

Export: Release 10.2.0.1.0 - Production on Wednesday, 15 October, 2008 2:30:48

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Job: EXPFULL
Owner: L5M
Operation: EXPORT
Creator Privs: FALSE
GUID: 593AB82552503A46E04011AC833D2FB9
Start Time: Wednesday, 15 October, 2008 2:30:53
Mode: FULL
Instance: orcl
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND l5m/******** directory=dpdata dumpfile=full.dmp full=y job_name=expfull
State: IDLING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /home/oracle/full.dmp
bytes written: 73,728

Worker 1 Status:
State: UNDEFINED

重新启动导出

Export> start_job

Export> help
The following commands are valid while in interactive mode.
Note: abbreviations are allowed

Command Description
------------------------------------------------------------------------------
ADD_FILE Add dumpfile to dumpfile set.
CONTINUE_CLIENT Return to logging mode. Job will be re-started if idle.
EXIT_CLIENT Quit client session and leave job running.
FILESIZE Default filesize (bytes) for subsequent ADD_FILE commands.
HELP Summarize interactive commands.
KILL_JOB Detach and delete job.
PARALLEL Change the number of active workers for current job.
PARALLEL=.
START_JOB Start/resume current job.
STATUS Frequency (secs) job status is to be monitored where
the default (0) will show new status when available.
STATUS[=interval]
STOP_JOB Orderly shutdown of job execution and exits the client.
STOP_JOB=IMMEDIATE performs an immediate shutdown of the
Data Pump job.

如果需要中止导出,可以用kill_job
Export> kill_job
Are you sure you wish to stop this job ([yes]/no): y

同时Master Table表也不见了.

SQL> select owner,TABLE_NAME,STATUS From dba_tables where table_name='EXPFULL';

no rows selected

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17252115/viewspace-731603/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-11-24

  • 博文量
    798
  • 访问量
    3214790