Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: resore a database at a specific daytime

Re: resore a database at a specific daytime

From: Mark Bole <makbo_at_ecis.com>
Date: Thu, 22 Nov 2001 14:12:16 GMT
Message-ID: <3BFD07C0.E4BDBFE0@ecis.com>


This is still very puzzling. There is a section in the "Oracle 8i Backup and Recovery Guide" called "Restoring Pre-RESETLOGS Backups" that seems to address this, but after studying this section several times, I still can't get it to work (or just don't understand).
To re-state the scenario,

  1. shutdown normal
  2. perform cold backup (copy all files)
  3. startup again, normal archived redo logs are generated for some period of time, say, one day.
  4. now I want to restore the cold backup, and roll forward some of the archived redo logs (up to some point in time).

As the original poster said, Oracle doesn't want to, it states "no media recovery required". I want it to recover anyway. How?

"Howard J. Rogers" wrote:

> There's absolutely no reason to use 'backup controlfile' unless you are
> actually restoring a binary version of the control file.
>
> A 'recover until time', as for any incomplete recovery, requires that you
> restore all data files, and do NOT resotre any of the online logs (which
> shouldn't be being backed up anyway), nor the controlfile.
>
> If data files are restored, but not controlfiles, then there is an
> inconsistency which *must* require recovery. Only if you are restoring
> *everything* will you not be prompted for recovery. It is impossible, if
> you are doing everything correctly, NOT to be asked for logs to be applied.
>
> Regards
> HJR
> --
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>

[...] Received on Thu Nov 22 2001 - 08:12:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US