Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-01194: file string needs more recovery to be consistent



ORA-01194: file string needs more recovery to be consistent..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22895: referenced table "string" in schema "string" is not an object table

1 Answers  


TNS-01096: %s * string * string * string * string * number

1 Answers  


IMG-00550: invalid scanlineOrder specified

1 Answers  


ORA-23462: flavor string in use at site string

1 Answers  


ORA-07842: sllfcl: SYS$CLOSE failure

1 Answers  






ORA-13866: Client identifier must be specified

1 Answers  


ORA-24183: invalid transformation

1 Answers  


NZE-29228: Cannot calculate the number of bytes for output.

1 Answers  


TNS-01161: Spawn alias string was not found. Check listener parameter file

1 Answers  


ORA-02815: Unable to attach shared memory

1 Answers  


RMAN-10029: unexpected return code number from PL/SQL execution

1 Answers  


ORA-01940: cannot drop a user that is currently connected

1 Answers  






Categories