Cry about...
Oracle Troubleshooting
Oracle Storage Manager shows a database as needing recovery
Symptom:
Oracle storage manager shows a database as needing recovery.
Cause:
Oracle has identified that some corruption has occurred on the database.
Possible Remedies:
- Try: (this requires archive logs)
Recover datafile ‘<datafile-name>’; - Restore the database from backup and reapply any archive log files.
- 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: Brian Cryer 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.