Simple Recovery Question

  • From: DBA Deepak <oracle.tutorials@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 7 Dec 2005 09:44:17 +0530

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

Other related posts: