Robert
Can you please highlight the plan like if I need to stop the database for this
one recovery or can go while environment is up and taking only this datafile
offline. Also I did earlier point in time recovcery using point -int time to
11:am and so do I need to do the same now or can just say restore and then
simple recover
Please guide high level steps
TIASanjay
On Tuesday, March 22, 2016 5:38 PM, Robert Freeman
<rfreeman@xxxxxxxxxxxxxxxxx> wrote:
Recovery of a datafile through resetlogs possible. Just make sure you have all
the archived redo logs needed for the restore.
Rf
Robert G. FreemanDBA, Troublemaker, MalcontentBusinessolver
On Mar 22, 2016, at 4:35 PM, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:
Robert
It is 11.2.0.3.
TxSanjay
On Tuesday, March 22, 2016 5:26 PM, Robert Freeman <rfreeman@xxxxxxxxxxxxxxxxx>
wrote:
Version?
Robert G. FreemanDBA, Troublemaker, MalcontentBusinessolver
On Mar 22, 2016, at 4:01 PM, Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx> wrote:
Hi
Just want to know that if I had opened the database after some point in time
recovery and open with reselogs and working but later got one datafile
corrupted after an hour. Can I able to restore the same corrupted file from
older backup as there is no new backup done after restlogs and recover that
file to same point in time recovery or so.
Please update the recovery of such scenario. This datafile is only datafile
belongs to one of the Application Tablespace.
TIASanjay