Restarting database in middle of patch application(adop/adpatch)

[satish]

Dear Erman,

Lets suppose we are applying a patch and it failed after 2 hours.Lets assume the fix is to set some database parameter and bounce the database.Is it possible to bounce the database and restart the patch from where it failed.

My concern is if we bounce the database,the worker database sessions may be gone right?

Thank you

[ErmanArslansOracleBlog]

It is a little problematic, but you should be able to..
If you stop the adop properly, then you should be able to continue from where it left of using the restart=yes abandon=no parameters.

I mean first tell the worker to stop using adctrl

adctrl
Select option:  
   1. Show Worker Status then
   4. Tell manager that a worker failed its job

then restart your db.
Lastly, execute adop with restart=yes abandon=no.