Re: Corrupted dbf file... help!!

From: Helma <helma.vinke_at_hotmail.com>
Date: Tue, 11 Sep 2007 04:11:06 -0700
Message-ID: <1189509066.251036.316920@22g2000hsm.googlegroups.com>

> > I shutdown the database using shutdown abort and now one of the db
> > file is corrupted. I am not able to startup the database anymore.....
> > NOTE: the database is in the noarchivelog mode. Does it mean, the
> > whole database is non-recoverable? HELP..... thanks!!!!

I've had such a problem once where a junior shut down the database and deleted a datafile. Luckily, it was from an indextablespace. So i was able to drop that one and rebuilded it. Possible here?

Your question: " the database is in the noarchivelog mode. Does it mean, the
> > whole database is non-recoverable?"

it seems you have a live experiment now to test this theory. Remember: A couple of months in the laboratory can frequently save a couple of hours in the library. ;-)

H. Received on Tue Sep 11 2007 - 06:11:06 CDT