Prev | Current Page 613 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"


Stopping and Restarting Running Jobs
After you have started a Data Pump Export job, you can close the client window you used to start
the job. Because it is server based, the export will continue to run. You can then attach to the job,
check its status, and alter it. For example, you can start the job via expdp:
expdp rjb/rjb parfile=dp_rjb.par
Press CTRL-C to leave the log display, and Data Pump will return you to the expdb prompt:
Export>
Chapter 11: Backup and Recovery Options 401
Exit to the client using the exit_client command:
Export> exit_client
Later, you can restart the client and attach to the currently running job under your schema:
expdp rjb/rjb attach
If you gave a name to your Data Pump Export job (or you identify the job name in the log file
when the job started), specify the name as part of the attach parameter. For example, if you had
named the job RJB_JOB, attach to the job by name:
expdp rjb/rjb attach=RJB_JOB
When you attach to a running job, Data Pump will display the status of the job: its basic
configuration parameters and its current status. You can then issue the continue_client command
to see the log entries as they are generated, or you can alter the running job:
Export> continue_client
In addition, you can stop a job using the stop_job command:
Export> stop_job
The job is not canceled, only suspended. With the job stopped, you can then add additional
dump files in new directories via the ADD_FILE option.


Pages:
601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625
tematy apteka kalabria tematy tematy