Re: Best way to restore database back to previous point in time

Am Donnerstag, 20. März 2014 13:17:08 UTC+1 schrieb Max Powers:
> Am Donnerstag, 20. März 2014 13:03:27 UTC+1 schrieb Preston:
>
> > patrick.gunia_at_googlemail.com wrote:
>
> >
>
> >
>
> >
>
> > > Hi everybody,
>
> >
>
> > >
>
> >
>
> > > I have a question concerning the best way to restore a database to a
>
> >
>
> > > previous point in time. My concrete intention is a little bit
>
> >
>
> > > different from the usual backup-purpose. As I´m working on
>
> >
>
> > > performance testing I´d like to have a fixed backup (or several
>
> >
>
> > > backups) which all have a fixed state in time. I load such a state,
>
> >
>
> > > run my benchmarks (which alter the database) and afterwards roll the
>
> >
>
> > > database back to the state before I started my test. So when I
>
> >
>
> > > restore my database I explicitely don´t want any recovery (because I
>
> >
>
> > > don´t want the database to return to the current state).
>
> >
>
> >
>
> >
>
> > What's the reason for not using flashback?
>
> >
>
> >
>
> >
>
> > --
>
> >
>
> > Preston.
>
>
>
> As far as I read about flashback it´s mainly used for quite recent backups. Maybe I got that wrong. Is it possible to use flashback providing it with a concrete backuppiece? Or does it require "automatic" backup-functionality?

I just read the documentation and it sounds like I first got it wrong and GUARANTEED restore points are what I´m looking for...I´ll give it a try and see, if it works out... Received on Thu Mar 20 2014 - 13:42:20 CET