Before attempting a fix, the DBA must ascertain why the database is in this state.

Run the following query to confirm the state:

Use only if files exist but recovery fails (e.g., log corruption):