recovery error 2004-07-13 - By zhu chao
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@(protected) > 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
