RE: database restore question (Urgent!)
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: "Mark W. Farnham" <mwf@xxxxxxxx>, <roger_xu@xxxxxxxxxxx>, "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Dec 2004 16:33:56 -0500
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@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" 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@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 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.
____________________________________________________________________
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
Other related posts:
