Re: recovery error
- From: Mike Hennesy <orcl9ps8dba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 14 Jul 2004 07:49:54 -0700 (PDT)
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@xxxxxxxxx> 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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
