DATABASE RECOVERY

From: R. Lewis <rlewis_at_provair.com>
Date: Wed, 27 Feb 2002 12:40:53 -0330
Message-ID: <a5j0g3$r9o$1@horsefly.nf.net>

Help!!

Here's the situation.

Oracle 7 database running in NOARCHIVELOG mode Full Database backup performed nightly (or so they thought!)

Now we have a failed hard drive and are trying to restore the database. Much to the surprise of the person who set up the backups they were failing. It looks like we have a complete set except for one datafile which is on another tape (from a backup two nights before) Is there anyway we can restore this database. I've been trying for days using all the info I can get from the manuals but I keep hitting walls. Can we uase the file from the other tape with the files from the almost complete set. Is there any way to tell oracle not to restore that one file. At this point I don't care about the data loss.

Any help would be appreciated.

Thanks
Rhonda Received on Wed Feb 27 2002 - 10:10:53 CST