Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: database restore question (Urgent!)

RE: database restore question (Urgent!)

From: Roger Xu <>
Date: Wed, 1 Dec 2004 17:28:54 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F7059C9128@irv2kexch01>

It worked and the database is up and running.

Thank y'all.

-----Original Message-----
From: Jeremiah Wilton [] Sent: Wednesday, December 01, 2004 3:16 PM To: Roger Xu
Cc: Oracle-L_at_Freelists. Org (E-mail)
Subject: Re: database restore question (Urgent!)

On Wed, 1 Dec 2004, Roger Xu wrote:

> 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?

Yes. You will have to apply all redologs from Friday forward. Apply time of logs generated prior to the Sunday backup will be faster than if you restored all files from Friday's backup.

Good luck, and let us know how it goes.

Jeremiah Wilton
Independent Oracle Professional
Oracle Certified Master
Disaster Recovery - Seminars - Technical Interviews

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
Received on Wed Dec 01 2004 - 17:24:21 CST

Original text of this message