Hi Gurus, I have a recovery scenario as given below... T1> Hot backup taken of the whole database. T2> A new tablespace TS05 created in the database. T3> Database crashes and all data files got corrupted. NOTE: All the archive logs are intact and no back up for TS05 tablespace exists. How to get the recover the database till time T3? Would appreciate if a step by step solution is given to the above scenario. -- Regards, Deepak Oracle DBA