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

On Thursday, March 20, 2014 8:42:20 AM UTC-4, Max Powers wrote:
> 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...

If you want to restore an existing database from a cold/offline backup without recovery you should first retrieve the control file out of the backup. Then you restore using a backup control file. Otherwise Oracle will see the current control file and want to restore to it's SCN. You use reset logs to open.

HTH -- Mark D Powell -- Received on Sat Mar 22 2014 - 00:18:17 CET