| 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: database restore question (Urgent!)
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] =
On Behalf Of Mark W. Farnham
Sent: Thursday, 2 December 2004 8:34 AM
To: Mark W. Farnham; roger_xu_at_dp7uptx.com; Oracle-L_at_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_at_rsiz.com]
Sent: Wednesday, December 01, 2004 4:28 PM
To: roger_xu_at_dp7uptx.com; Oracle-L_at_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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu
Sent: Wednesday, December 01, 2004 4:09 PM
To: Oracle-L_at_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.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 01 2004 - 16:20:49 CST
 |
 |