Error with Oracle temp file after Offline restore
551760Aug 16 2007 — edited Aug 16 2007Hi,
I did a offline backup of my Oracle 9I database after shutting down the DB. After I restore the offline file system backup, I saw the following error in alter.log:
"ORA-01186: file 255 failed verification tests
ORA-01122: database file 255 failed verification check
ORA-01110: data file 255: '/oracle/SED/sapdata1/temp_1/temp.data1'
ORA-01205: not a data file - type number in header is 0
File 255 not verified due to error ORA-01122"
When I did a query I got the following error :
"SQL> select * from dba_temp_files;
select * from dba_temp_files
*
ERROR at line 1:
ORA-01187: cannot read from file 255 because it failed verification tests
ORA-01110: data file 255: '/oracle/SED/sapdata1/temp_1/temp.data1'
I know how to recover it but Why is this so ? Is this normal when I restore the offline backup file including the temp.data1 ?
Any reply is appreciated.
Rgds,
WP