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:

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.