Re: Corrupted dbf file... help!!

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Mon, 10 Sep 2007 05:31:07 -0700
Message-ID: <1189427467.442279.79100@50g2000hsm.googlegroups.com>

On Sep 10, 10:32 am, Kaka <kaka...._at_gmail.com> wrote:

This:

> fuser -cu /u01/oradata/ax5.old/data014.dbf
> /u01/oradata/ax5.old/data014.dbf: fuser: No such file or directory

and this:

> *** SESSION ID:(2.1) 2007-09-09 16:38:37.334
> ORA-01157: cannot identify/lock data file 198 - see DBWR trace file
> ORA-01110: data file 198: '/u01/oradata/ax5/data014.dbf '

are not the same pathname for this file.

Something is missing. Either someone has unknowingly changed pathnames or there is a symlink missing somewhere in all this.

One - rough - way to get pathnames of all files that should be in a database - if you really don't know tha already - is to run a "strings" on the control file: that should list all pathnames involved as well as a bucketload of other stuff not relevant for this.

You'll have to pour through the output to get the pathnames out. Once that's done, x-check against existing pathnames in the file system and make sure there are no differences anywhere. Received on Mon Sep 10 2007 - 07:31:07 CDT