| 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!)
One caveat: I doubt you did a resetlogs recovery in between Friday night and
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" files 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 Monday
3 p.m.
The last two backups was performed Sunday night and Friday night and all the
archived logs are in the original place.
After 13 hours of tape restore, we found out one of the DLT tapes is bad. We
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
Received on Wed Dec 01 2004 - 15:30:24 CST
 |
 |