| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: recovery error
I guess I didn't make myself real clear. My main issue is why the recover database didn't appear to work as I expected.
SVRMGR> recover database until time '2004-07-01:04:30:00';
Media recovery complete.
The above recover command completed in a second which is way too fast for a days worth of data.
Querying v$datafile after the recover command finished shows the checkpoint_time and last_time to still be 6/30 AM where I would expect '2004-07-01 04:30:00' after recovery complete.
STATUS CHECKPOINT CHECKPOINT_TIME LAST_TIME
_CHANGE#
------- ---------- ------------------- -------------------
SYSTEM 581863533 2004-06-30 04:02:52 2004-06-30 04:02:52
ONLINE 581863533 2004-06-30 04:02:52 2004-06-30 04:02:52
2 rows selected.
My main concern is why the instance didn't recover to 7/1. Anyone have any insight into this I'd appreciate it.
My secondary concern was which files do I need to re-recover due to the alter system archive log all command being issued even though the instance wasn't recovered thru 7/1/04. Can I just try to do the recover over with some different syntax?
SVRMGR> recover database until time '2004-07-01:04:30:00';
Media recovery complete.
SVRMGR> ALTER SYSTEM ARCHIVE LOG ALL;
Statement processed.
Oracle 8.1.7.3
Thanks - Mike
zhu chao <zhuchao_at_gmail.com> wrote: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
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 ----------------------------------------------------------------- --------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! ---------------------------------------------------------------- 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 Wed Jul 14 2004 - 09:49:08 CDT
 |
 |