Re: Best way to restore database back to previous point in time
From: Preston <dontwantany_at_nowhere.invalid>
Date: Thu, 20 Mar 2014 12:03:27 +0000 (UTC)
Message-ID: <lgelef$f1v$1_at_dont-email.me>
Date: Thu, 20 Mar 2014 12:03:27 +0000 (UTC)
Message-ID: <lgelef$f1v$1_at_dont-email.me>
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.Received on Thu Mar 20 2014 - 13:03:27 CET