ORA-01122: database file 1001 failed verification check
Hi Gurus
Could you please help solve this issue?
Errors in file /opt/app/oracle/admin/HMPROD/bdump/hmprod_dbw0_28567
.trc:
ORA-01186: file 1001 failed verification tests
ORA-01122: database file 1001 failed verification check
ORA-01110: data file 1001: '/opt/app/oradata01/HMPROD/dbf/temp_01.dbf
'
ORA-01203: wrong incarnation of this file - wrong creation SCN
Wed Oct 7 16:05:53 2009
File 1001 not verified due to error ORA-01122
Wed Oct 7 16:05:53 2009
Dictionary check complete
Wed Oct 7 16:05:53 2009
SMON: enabling tx recovery
Wed Oct 7 16:05:53 2009
Cannot re-create tempfile /opt/app/oradata01/HMPROD/dbf/temp_01.dbf,
the same name file exists
Thanks
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.