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, > > > >