All Oracle Error CodesOracle DBA Forum

ORA-01194:

file string needs more recovery to be consistent
Cause: An incomplete recovery session was started, but an insufficient number of logs were applied to make the file consistent. The reported file was not closed cleanly when it was last opened by the database. It must be recovered to a time when it was not being updated. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery.
Action: Either apply more logs until the file is consistent or restore the file from an older backup and repeat recovery.
 SubjectReplies
1.Can't open database10
2.Production DB Crash Recovery process - Some imm...5
3.hot-backup recovery question4
4.hot-backup recovery question4
5.database duplication3
6.RE: Recovery Help?2
7.Production Database Crash Recovery process - So...2
8.Production DB Crash Recovery process - Some imm...2
9.Open read only after incomplete recovery?2
10.Can't open database1
11.Open read only after incomplete recovery?1
12.Seeking help with RMAN1