Did this get fixed? I frequently need to apply recovery from one of the redo logs when cloning databases. I am not sure what causes this but I know it works. I guess I ought to figure out why, anyone know the answer to that? File 1 is system I think that is usually the same error I see when redo log is required for recovery. - Ethan On 2/11/06, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> wrote: > With a Production Crash on Hands, some urgent advice would help Folks:- > > Aim - To Recover the Database upto 6 pm Point in time of 11 Feb 2006. > > Using CANCEL based recovery upon attempting to open the Databse > following Error is occurring:- > > ORA-01194: file 1 needs more recovery to be consistent -- //www.freelists.org/webpage/oracle-l