Ora-01122:database File 4 failed verification check

Phenomenon:

When you do a table space recovery walkthrough, you encounter the following error message:

sql> ALTER DATABASE datafile 4 online;
ALTER DATABASE datafile 4 online
*
ERROR at line 1:
Ora-01122:database File 4 failed verification check
Ora-01110:data file 4: '/ORA/APP/ORACLE/ORADATA/ORCL/USERS01.DBF '
Ora-01210:data file header is media corrupt

Workaround:

Analysis Reason:

[Email protected] hotback]$ Oerr ora 1122
01122, 00000, "database file%s failed verification Check"
*cause:the information in this file was inconsistent with information
From the control file. See accompanying message for reason.
*action:make certain that the db files and control files is the correct
Files for this database.
[Email protected] hotback]$ Oerr ora 1110
01110, 00000, "Data file%s: '%s '"
*cause:reporting file name for details of another error. The reported
Name can be of the old file if a data file move operation is
In progress.
*action:see associated error message.
[Email protected] hotback]$ Oerr ora 1210
01210, 00000, "Data file header is media corrupt"
*cause:the file Header block is internally inconsistent. The beginning
of the block have a header with a checksum and other data for
Insuring the consistancy of the block. It's possible that
The last disk write does not operate correctly. The most likely
Problem is, which is the not a datafile for any database.
*action:The operating system make correct file available to database.
If The trace file dump indicates that's the checksum is wrong,
Restore from a backup and do media recovery.

Basically, the restored data file is not correct. After careful examination, sure enough is:

Ho cp '/ora/app/oracle/backup/hotback/con01.ctl'/ora/app/oracle/oradata/orcl/users01.dbf'

The backup control file when the data file to restore back!

Re-restore:

Sql> ho cp '/ora/app/oracle/backup/hotback/users01.dbf'/ora/app/oracle/oradata/orcl/users01.dbf '

The next steps are performed correctly.

Ora-01122:database file 4 failed verification check