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, 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/271283/viewspace-471138/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/271283/viewspace-471138/