If the Hot Backup began at 10AM and completed at 11:45AM, you must switch and archive the CURRENT and ACTIVE REDO LOG files out and include these Archivelog in your backupset. If it was a Snapshot/Snapclone backup where the database was in backup mode for only a few seconds or a minute, you must *still* switch and archive the CURRENT and ACTIVE REDO LOG files out and include the Archivelogs in your backup set.
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 -- http://www.freelists.org/webpage/oracle-l
Hemant K Chitale http://web.singnet.com.sg/~hkchital