ORA-01122: database file 58 failed verification check

[former_member389036]

Hi All,

I have lost one of my datafile while moving them from 1 drive to another. I am getting the following error while trying to start the database:

ORA-01122: database file 58 failed verification check

ORA-01110: data file 58: 'G:\ORACLE\R3E\SAPDATA7\R3E700_25\R3E700.DATA25'

ORA-01251: Unknown File Header Version read for file number 58

Please suggest what can be done to correct the error. Also I don't have a backup.

Suman

[former_member389036]

Hi Markus,

I am using oracle 10g and I don't have a backup. What shall I do now?

Suman

[markus_doehr2]

You can´t do anything but restoring a backup. If you don´t have one then you´re lost - unfortunately... The datafile is corrupt and this can only be "repaired" using a backup and applying archive logs.

--

Markus

[markus_doehr2]

- open http://service.sap.com/notes

- enter "ORA-01251"

- you will find Note 696141 - Composite SAP Note: ORA-01122

and that section:

[...]

10. ORA-01251: Unknown File Header Version read for file number <file_id>

• Reason: The file header cannot be correctly read.

• Solution: If you use Oracle 9.2 on WINDOWS and if you already installed the database with Oracle 7.2 or lower, see Note 636466.

Otherwise: Restore/recovery

[...]

--

Markus