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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l