Cry about...
Oracle Troubleshooting

Oracle Storage Manager shows a database as needing recovery


Oracle storage manager shows a database as needing recovery.


Oracle has identified that some corruption has occurred on the database.

Possible Remedies:

  1. Try: (this requires archive logs)

    Recover datafile ‘<datafile-name>’;

  2. Restore the database from backup and reapply any archive log files.
  3. If the database is a standby database then check the procedure for copying the file in the first place. A common mistake is to perform a hot backup of a database but without issuing a ‘alter tablespace ... begin backup ... end backup’ for the tablespace in question.

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.

About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.