oracle停止expdp 039,expdp的停止与重启动

expdp的停止与重启动

[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, 2:23:47

Copyright (c) 2003, 2005, . 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