ORA-01242: data file suffered media failure - ORA-01208: data file is an
633160Apr 9 2008 — edited Apr 9 2008Hi,
I am running Oracle 9.2.0.5 and if fails almost on a daily basis.
I get the following errors:
*** 2008-04-09 09:31:46.334
*** SESSION ID:(4.1) 2008-04-09 09:31:46.318
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: 'E:\ORACLE\ORADATA\MYDB\MYDB.ORA'
ORA-01208: data file is an old version - not accessing current version
error 1242 detected in background process
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: 'E:\ORACLE\ORADATA\MYDB\MYDB.ORA'
ORA-01208: data file is an old version - not accessing current version
I run the following SQL and DB is recovered but I can't keep doing this everytime it crashes:
sqlplus>startup nomount;
sqlplus>alter database mount;
sqlplus>alter database recover;
sqlplus> alter database open;
Any ideas how can I resolve this problem.
Regards
Spiros