Re: point in time recovery when there is no backup ?

  • From: Harel Safra <harel.safra@xxxxxxxxx>
  • To: sjaffarhussain@xxxxxxxxx
  • Date: Wed, 2 Feb 2011 22:29:11 +0200

You can try using logminer to mine the archives and apply the undo sql in
opposite order.
It's not the most robust of solutions, but it can help sometimes.

Harel Safra

On Wed, Feb 2, 2011 at 9:50 PM, Syed Jaffar Hussain <
sjaffarhussain@xxxxxxxxx> wrote:

> Just to make the point clear. Neither there is any prior backup nor any
> flashback feature is enabled. The db is in archive log mode and fortunately
> all the archive logs are available. I need to duplicate this database to
> back in time, probably a day before.
>
> Regards,
>
>
>
>

Other related posts: