Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: resore a database at a specific daytime
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,
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
![]() |
![]() |