Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recovery from online backups/archived logs on another system
Matthew
Been there, done that. I've run into the phenomenon where recovery asks for an SCN and suggests a log that contains that SCN. Oracle then applies all the changes in that log, which prompts it to need just one more SCN, and suggests a log. It never ends. If you recover to an SCN that is in the next log, then recovery is satisfied. Now I should clarify that this is when you are using RESETLOGS. I think you've had better suggestions by switching logs, or bringing over the current logs.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Matthew J. Brown
Sent: Wednesday, April 14, 2004 2:40 PM
To: oracle-l_at_freelists.org
Subject: RE: Recovery from online backups/archived logs on another
system
This makes sense except for the fact that I've applied logs for about 4 hours worth of data AFTER the online backups. The dates on the last system change numbers applied are substantially after the end of the online backup completion.
-Matt
-----Original Message-----
From: Stephen.Lee_at_DTAG.Com [mailto:Stephen.Lee_at_DTAG.Com]=20
Try going back to the original, do a couple of log switches, then grab
the
archived logs and copy them over. The online redo files on the original
are
at whatever system change number the copied database is looking for.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |