ORA-01210: data file header is media corrupt

    ORA-00283: recovery session canceled due to errors
    ORA-01110: data file 24: 'D:\app\Ram\oradata\DATAGUARD\system02.DBF'
    ORA-01122: database file 24 failed verification check
    ORA-01110: data file 24: 'D:\app\Ram\oradata\DATAGUARD\system02.DBF'
    ORA-01210: data file header is media corrupt




Error Cause:
The file header block is internally inconsistent. The beginning of the block has a header with a checksum and other data for insuring the consistancy of the block. It is possible that the last disk write did not operate correctly. The most likely problem is that this is not a datafile for any database.


Solution :

Have operating system make correct file available to database. If the trace file dump indicates that only the checksum is wrong, restore from a backup and do media recovery.

 Or The Below Solution , You Must Be Sure that you have Valid Backup to restore it .


    SQL> shutdown immediate
    SQL > Startup mount
    SQL> ALTER DATABASE DATAFILE 'D:\app\Ramtech\oradata\dataguard\system02.DBF' OFFLINE ;
    SQL > ALTER database Open ;




Cheers!