Re: DATABASE RECOVERY

This is a really good time to go to management and tell them they were so busy pinching pennies that they just cost themselves thousands. They'll be more receptive now than after you fix the problem.

I'd create two new instances. One for one backup set ... another for the stand-alone datafile. Then try to merge them using a database link. Likely it will be a horrible mess. Undoubtedly it will cost them far more than good practices like testing backups regularly and turning on archive logging.

This might also be a great time to tell them that Oracle 7 hasn't been supported since the time before ball point pens were invented. Get them while they are most receptive to a dose of reality. Otherwise your resume will be about as valuable as that of an RPG2 expert.

Daniel Morgan

"R. Lewis" wrote:

> 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 - 12:57:29 CST