Home -> Usenet -> comp.databases.oracle -> Recovering from a corrupt DBF file

Recovering from a corrupt DBF file

From: Ron <ron_at_yippy.yappy>
Date: Sun, 15 Oct 2000 21:38:55 -0400
Message-ID: <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 - 03:38:55 CEST












Original text of this message