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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: recovery error

Re: recovery error

From: zhu chao <zhuchao_at_gmail.com>
Date: Wed, 14 Jul 2004 10:11:11 +0800
Message-ID: <962cf44b04071319111b891362@mail.gmail.com>


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



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
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

Original text of this message

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