| Stopping a impdp job [message #400099] |
Sun, 26 April 2009 02:33  |
psathya30
Messages: 4
Registered: May 2008
|
Junior Member |
|
|
Hi ,
Is it possible to stop a impdp job (using STOP_JOB) and restart it after a db bounce?If yes ,how will the master process be handled during the db startup/shutdown.The docs say that if the dump files and master table are undisturbed , then the job can be restarted with START_JOB.But how will/should be the master process handled?
We had to shutdown a db where an import was running for an urgent maintenance activity. We stopped the job using STOP_JOB. But during shutdown , we faced a problem as the master process(DM00)was till active.The shutdown was waiting for this active call to complete. So we killed this process for the shutdown to proceed.
After startup, when I try to attach to the import job again, it throws the following error
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-44003: invalid SQL name
ORA-39097: Data Pump job encountered unexpected error -44003
What is the procedure to stop and start a impdp/expdp job during a db bounce? [Oracle version : 10.2.0.1 , OS : Sun solaris V10 ]
Many thanks,
Sathya
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
