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

淩亂°似流年 2023-01-18 09:07 217阅读 0赞

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

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

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

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

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

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关正确停止Oracle expdp impdp作业的操作方法

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

相关 oracle远程expdp,oracle expdp 导出远程数据库

相关 oracle启动与停止,最简单的Oracle启动与停止笔记

相关正确停止expdp导出任务

相关 Oracle 数据库启动与停止

相关 Nginx的启动、停止与重启

相关 Nginx的启动、停止与重启

相关 Nginx的启动、停止与重启

相关 Nginx的启动、停止与重启