Re: Corrupted dbf file... help!!

From: Ruud de Koter <nobody_at_internet.org>
Date: Mon, 10 Sep 2007 09:50:31 +0200
Message-ID: <46e4f73d$0$227$e4fe514c@news.xs4all.nl>

Kaka,

the file you fusered (/u01/oradata/ax5.old/data014.dbf) is not the one mentioned in the trace (/u01/oradata/ax5/data014.dbf). It looks like someone has been moving around files to a .old directory.

In your case I would have a very good look that the files that Oracle expects to see are actually on disk. I don't know whether that will do any good, but checking a file that Oracle doesn't ask for is not very relevant.

Good luck,

Ruud de Koter.

Ana C. Dent wrote:
> Kaka <kaka.hui_at_gmail.com> wrote in news:1189384361.540802.228310
> @w3g2000hsg.googlegroups.com:
>

>> Does the file exist?
>> Answer: yes, but the weird thing is, when you try to do fuser on the
>> dbf file, apparantly the operating system does not see it.

>
>
> Sorry, you offer no proof to support answer of "YES, the file exists".
>
> I hope that the file that went missing did not contain any data you valued.
>
> IIRC, you should be able to force open the DB, but you're going to have
> hole in your data.
Received on Mon Sep 10 2007 - 02:50:31 CDT