Some more info :-
SVRMGR> select * from v$recover_file;
FILE# ONLINE ERROR CHANGE# TIME
---------- ------- ------------------ ---------- --------------------
81 OFFLINE 7846247 09/27/00 18:02:27
1 row selected.
> -----Original Message-----
> From: VIVEK_SHARMA
> Sent: Wednesday, October 11, 2000 11:44 PM
> To: 'ORACLE-L_at_fatcity.com'; 'oracledba_at_lazydba.com'
> Cc: 'kaygopal_at_yahoo.com'; 'gajav_at_yahoo.com'
> Subject: 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 like
> File size Differs for "/in1backup2/db3/bm2f/migr_roll_1_bm2f.dbf" at O.S.
> & Database Levels
> 4) Dropped the Datafile as it Contains Only one Rollback Segment which was
> Online during Crash
> alter database datafile /in1backup2/db3/bm2f/migr_roll_1_bm2f.dbf OFFLINE
> DROP;
> Statement processed
> 5) Database Open Succeeded
> 6) drop of Corresponding Tablespace Failing :-
> SVRMGR> drop tablespace tmp_migr including contents;
> drop tablespace tmp_migr including contents
> *
> 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 - 14:39:56 CDT
