About Me

Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G

Tuesday, April 9, 2013

Restore the backup Troubleshooting


While during the Restore Process , always try to set the database is in Single user Mode

During the restore process if the alert shows Exclusive access could not be obtained because the database is in use as follows


To resolve , Exec SP_who , identify if any user is still accessing the restore database and status will be in sleeping mode as follows.

kill 53

kill 54




No comments:

Post a Comment