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

From: Mark D Powell <markp28665_at_gmail.com>
Date: Fri, 21 Mar 2014 16:18:17 -0700 (PDT)
Message-ID: <b84d59bf-7e0f-41c3-9f89-b953a1cb21df_at_googlegroups.com>


On Thursday, March 20, 2014 8:42:20 AM UTC-4, Max Powers wrote:
> Am Donnerstag, 20. Mrz 2014 13:17:08 UTC+1 schrieb Max Powers:
>
> > Am Donnerstag, 20. Mrz 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 Im working on
>
> > performance testing Id 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 dont want any recovery (because I
>
> > > > dont 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 its 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 Im looking for...Ill 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

Original text of this message