Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

RE: database restore question (Urgent!)

From: Pete Sharman <peter.sharman@xxxxxxxxxx>
To: mwf@xxxxxxxx, roger_xu@xxxxxxxxxxx, "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 2 Dec 2004 09:23:36 +1100

Lie, lies, damned lies!  :)

It IS, in fact, possible to recover across an open resetlogs in versions pr=
ior to 10g, but it's a heck of a lot easier to do it in 10g.
 =

Pete
 =

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
 =

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] =
On Behalf Of Mark W. Farnham
Sent: Thursday, 2 December 2004 8:34 AM
To: Mark W. Farnham; roger_xu@xxxxxxxxxxx; Oracle-L@Freelists. Org (E-mail)=

Subject: RE: database restore question (Urgent!)

One caveat: I doubt you did a resetlogs recovery in between Friday night an=
d
Sunday, but until very recently Oracle recoveries could not roll across
openresetlogs (so you needed to do a double full backup after a open
resetlogs recovery in order to avoid trusting your career to a single piece=

of rusty ribbon.)

-----Original Message-----
From: Mark W. Farnham [mailto:mwf@xxxxxxxx]
Sent: Wednesday, December 01, 2004 4:28 PM
To: roger_xu@xxxxxxxxxxx; Oracle-L@Freelists. Org (E-mail)
Subject: RE: database restore question (Urgent!)


Yes, as long as you have the required logs. Oracle works perfectly well
doing a restore from heterochronous backups. You only need the "older" file=
s
in place of the missing "newer" files. You still have to crank through a
more archived redo logs, but the block updates are only applied when the
time is newer, so the more of the "newer" files you can use, the better.

Good luck!

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu
Sent: Wednesday, December 01, 2004 4:09 PM
To: Oracle-L@Freelists. Org (E-mail)
Subject: database restore question (Urgent!)


Hi list,

We need to do a point-in-time restore of one of our 9.2i databases to Monda=
y
3 p.m.
The last two backups was performed Sunday night and Friday night and all th=
e
archived logs are in the original place.
After 13 hours of tape restore, we found out one of the DLT tapes is bad. W=
e
are able to find out which files are in this
tape and there are 36 datafiles on it.

My question: Can we restore those 36 files from Friday night's backup?

Thanks,
Roger Xu



This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information. Any
review, dissemination, copying, printing or other use of this e-mail by
persons or entities other than the addressee is prohibited. If you have
received this e-mail in error, please contact the sender immediately and
delete the material.
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. Any questions please call 972-721-8257 or email your
request to tech_support@xxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

RE: database restore question (Urgent!)

Other related posts: