Home > Recovery > FORCE DATABASE OFFLINE

FORCE DATABASE OFFLINE

Recently I get into a situation where one of Database file freeze and stopped responding to any of the queries executed on the objects using the file

On killing the select statement it goes into rollback state with WAIT TYPE DISKIO_SUSPEND.

DISKIO_SUSPEND: Occurs when a task is waiting to access a file when an external backup is active. This is reported for each waiting user process. A count larger than five per user process may indicate that the external backup is taking too much time to finish.

Resolution: Forcefully take database offline.

ALTER DATABASE database-name SET OFFLINE WITH ROLLBACK IMMEDIATE

Bring the database Online

ALTER DATABASE database-name SET ONLINE

 

 

Categories: Recovery
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: