Re: Recovering from a corrupt DBF file

> offline drop

if you think that's real answer then better drop yourselve

> "Ron" <ron_at_yippy.yappy> wrote in message
> news:MPG.1454263f8c5362239896af_at_news.alt.net...
> > Okay -
> >
> > I hosed a DBF file used for rollback segments, i.e. an rbsXX.dbf file.
 I
> > corrupted it when I mistyped the "tar" command while doing an offline
> > backup, so I obviously have no backup for the file. (I miscopied the
> > "tar" command, actually. I was using the mouse to copy-n-paste a
 command
> > and I didn't pick up part of it. That'll teach me to be sloppy.)
> >
> > (This is Oracle 7.2 on Solaris 2.5.1, by the way.)
> >
> > Luckily, it's just a training/eval database and doesn't contain any
> > important data. But I want to figure out a way to fix this problem,
 just
> > in case it ever happens on a "real" system.
> >
> > The database seems to come up, after whining about the file it can no
> > longer recognize, but it doesn't really. Anybody who tries to access it
> > gets a "shutdown or initialization in progress" message, even after
> > several hours.
> >
> > Any ideas of how to recover from this without a backup? Is there a way
 I
> > can get the database to come up enough to allow me to go in and drop (or
> > otherwise remove) the affected rollback segments and then recreate them?
> >
> > Failing that, if I create a brand new database that's just like this one
> > in every way except for the data (I have a collection of scripts that do
> > all the work) then is there a way I can use the DBF files from the
> > corrupt database to populate the new database?
>
>
Received on Mon Oct 16 2000 - 14:23:00 CDT