Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to understand the stopping and starting and monitoring of ORACLE EXPDP IMPDP in Oracle". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to understand the stopping, starting and monitoring of ORACLE EXPDP IMPDP in Oracle".

The most essential difference between EXPDP/IMPDP and traditional exp/imp is that the server executes. After the client issues the assignment, the backup job of the server is started through API.

During execution, you can take down the Ctrl+C key combination and exit the current interaction mode. After exiting, the export operation will not stop. This is different from the previous EXP of Oracle.

In the previous EXP, if you exited interactive mode, there was an error terminating the export task.

In addition, after exiting the interaction, the expdp process is not visible on the server side with ps-ef | grep expdp.

First, in Oracle 10, because EXPDP is a task defined within the database, it has nothing to do with the client. After exiting the interaction, enter the

Command line mode of export, which supports viewing commands such as status:

Export > status

If you want to stop changing tasks, you can issue the stop_job command

Export > stop_job

You can then connect to this task again from the command line

C:\ expdp test/test@acf attach=expfull (fill in the job name here)

Restart the export through the start_job command

Export > start_job

2. Monitor the job of expdp:

Select * from dba_datapump_jobs;--- to view each job

Select * from dba_data_session;---- to view each session

3. Attach enters the interactive state, and common commands are used in the interactive state:

Status: check job status and monitor job progress

Stop_job: stop the task

Start_job: start the recovery task

Stop_job=IMMEDIATE will immediately shut down the data pump operation

Parallel=10 changes the number of active worker for the current job.

At this point, I believe you have a deeper understanding of "how to understand the stop and start and monitoring of ORACLE EXPDP IMPDP in Oracle". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.