Question:
I am getting this ORA-01210 error:
ORA-00283: recovery
session canceled due to errors
ORA-01110: data file 24: '/ora/data/gamesds/system02.DBF'
ORA-01122: database file 24 failed
verification check
ORA-01110: data file 24: '/ora/data/gamesds/system02.DBF'
ORA-01210: data file header is media
corrupt
Answer: The oerr utility show this
for the ORA-01210 error:
ORA-01210: data file header is media corrupt
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
consistency 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 '/ora/data/gamesds/system02.DBF'
OFFLINE ;
SQL
> ALTER database Open ;
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
