Re: DATABASE RECOVERY

Thanks for the replys, I got this fixed thanks to much appreciated help from Chad Smith.

Will run the upgrading by management again but I'm probably looking at Oracle 7 for another while yet!

"R. Lewis" <rlewis_at_provair.com> wrote in message news:a5j0g3$r9o$1_at_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 - 14:35:23 CST