Re: point in time recovery when there is no backup ?
From: Harel Safra <harel.safra_at_gmail.com>
Date: Wed, 2 Feb 2011 22:29:11 +0200
Message-ID: <AANLkTi=wBKueuf8nt6kjh7oBBuLzYk_xtiWySOsVKnco_at_mail.gmail.com>
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.
Date: Wed, 2 Feb 2011 22:29:11 +0200
Message-ID: <AANLkTi=wBKueuf8nt6kjh7oBBuLzYk_xtiWySOsVKnco_at_mail.gmail.com>
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_at_gmail.com> 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,
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 02 2011 - 14:29:11 CST