Re: ORA-01160: file is not a data file

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 23 Feb 2001 06:32:54 +0100
Message-ID: <7dtb9tctutf4achhkdsm6g2hrmnh3r58hr@4ax.com>

On Thu, 22 Feb 2001 20:52:59 GMT, "james" <kdhakal_at_eline.com> wrote:

>hello! I am trying to create a controlfile in new location in order to use
>all the datafile from another location and got this error:
>ORA-01503: CREATE CONTROLFILE failed
>ORA-01160: file is not a data file
>ORA-01110: data file : '/u07/path1/system01.dbf'
>I am little confused with this error, because why is the system file not a
>data file? I copied this system file from last nights hot backup.
>I am using oracle 8.1.5 on Solaris. Thanks.
>
>
>

I am afraid it means Oracle doesn't recognize the file as a database file (ie the file has an invalid header), so it means your backup is corrupt.

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Feb 22 2001 - 23:32:54 CST