- not restoring the file and opening the DB
svrmgrl
connect internal
startup mount
alter database datafile '<absolute path>/<dbfile name>' offline drop ;
alter database open ;
- restoring the file from tape and recover the data inconsistently
only possible with DUL from Oracle support
"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 - 12:19:38 CST
