ORA-1122, ORA-1110, ORA-120X (Doc ID 1011557.6)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Information in this document applies to any platform.

Symptoms

You are receiving the following errors:

ORA-01122: "database file %s failed verification check"
Cause: The information in this file is inconsistent with information
from the control file. See accompanying message for reason.
Action: Make certain that the db files and control files are the correct
files for this database.

ORA-01110:"data file %s: '%s'"
Cause: Reporting file name for details of another error
Action: See associated error message
01110, 00000, "data file %s: '%s'"

And one of the following:

ORA-01201: "file size %s in header does not match size %s in control file"
Cause: The file sizes in the control file and in the file header do not match. One of them is probably a corrutped value.
Action: Replace the corrupted file with a good one and do recovery as needed.

ORA-01202: "wrong incarnation of this file - wrong creation time"
Cause: The creation time in the file header is not the same as the creation time in the control file. This is probably a copy of a file that was dropped.
Action: Restore a current copy of the data file and do recovery as needed.

ORA-01203: "wrong incarnation of this file - wrong creation SCN"
Cause: The creation SCN in the file header is not the same as the creation SCN in the control file. This is probably a copy of a file that was dropped.
Action: Restore a current copy of the data file and do recovery as needed.

ORA-01204: "file number is %s rather than %s - wrong file"
Cause: The file number in the file header is not correct. This is probably a restored backup of the wrong file, but from the same database.
Action: Restore a copy of the correct data file and do recovery as needed.

ORA-01205: "not a data file - type number in header is %s"
Cause: The file type in the header is not correct for a data file. This is probably a log file or control file. If the type is not a small non-zero positive number then the header is corrupted.

ORA-01206: "file is not part of this database - wrong database id"
Cause: The database id in the file header does not match the database id in the control file. The file may be from a different database, or it may not be a database file at all. If the database was rebuilt, this may be a file from before the rebuild.
Action: Restore a copy of the correct data file and do recovery as needed.

You may notice that the file Oracle is complaining about is offline in v$datafile.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms