Home » RDBMS Server » Server Utilities » Stopping a impdp job (Oracle 10g ( 10.2.0.1))
Stopping a impdp job [message #400099] Sun, 26 April 2009 02:33 Go to next message
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
Re: Stopping a impdp job [message #400129 is a reply to message #400099] Sun, 26 April 2009 06:44 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


What type of command did you used for down your database ???

Babu
Re: Stopping a impdp job [message #400172 is a reply to message #400129] Sun, 26 April 2009 22:37 Go to previous message
psathya30
Messages: 4
Registered: May 2008
Junior Member
Babu,
We used ' SHUTDOWN IMMEDIATE ' to bring down the db.

Thanks,
Sathya
Previous Topic: Conventional path in SQLLoader
Next Topic: restoring database into the existing database
Goto Forum:
  


Current Time: Fri Mar 29 00:07:22 CDT 2024