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