| 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!)
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:24:48 CST
 |
 |