Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Drop Tablespace failing
Following Sequence of events
1) DMLs happening on a Database with a Particular Rollback Segment Online 2) Machine Shutdown Abnormally 3) Upon Booting Machine , Database Open failing with the Message likeFile size Differs for "/in1backup2/db3/bm2f/migr_roll_1_bm2f.dbf" at O.S. & Database Levels
ORA-00604: error occurred at recursive SQL level 1 ORA-00376: file 81 cannot be read at this time ORA-01110: data file 81: '/in1backup2/db3/bm2f/migr_roll_1_bm2f.dbf'
NOTE
1) Export Failing with the Oracle Errors
2) SVRMGR> select * from sys.dba_data_files
2> order by tablespace_name,bytes;
FILE_NAME FILE_ID TABLES PACE_NAME BYTES BLOCKS STATUS ---------------------------------------------------------------------------- ---- ---------- ------ ------------------------ ---------- ---------- ---------ORA-00376: file 81 cannot be read at this time ORA-01110: data file 81: '/in1backup2/db3/bm2f/migr_roll_1_bm2f.dbf' Received on Wed Oct 11 2000 - 13:14:01 CDT