Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: recovery error
Are you sure the datafiles your restored are backuped on 6/30 5:00am?
After create the controlfile, can you query the v$datafile ? like the
checkpoint_time ?
I guess your restored datafiles are newer than 7/1 at 4:30 AM.
And, as others noted, after recover until time, you did an incomplete recovery. You must open database resetlogs before doing other things.
On Tue, 13 Jul 2004 12:24:12 -0700 (PDT), Mike Hennesy
<orcl9ps8dba_at_yahoo.com> wrote:
> I just had this dropped on my desk. Oracle 8.1.7.3 . The objective was to restore a backup of PRD on a different host and recover from the 6/30 5:00 AM backup until 7/1 at 4:30 AM.
>
> I was told that the media recovery complete was almost instantaneous (didn't show processing of any archive logs, should have processed 15) and the ALTER SYSTEM ARCHIVE LOG ALL took about 45 seconds to complete.
> --
Regards
Zhu Chao
www.cnoug.org
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Jul 13 2004 - 21:07:59 CDT
![]() |
![]() |