Hi Vivek,
Similar thing happened to me a couple of days ago. I shutdown the database,
got the SA to 'fsck' the file system, and then dropping the tablespace
worked fine.. In my case the datafile was 'resized' in the older vesion of
oracle by the ex-DBA...
HTH..
- Kirti
> -----Original Message-----
> From: VIVEK_SHARMA [SMTP:VIVEK_SHARMA_at_infy.com]
> Sent: Wednesday, October 11, 2000 2:17 PM
> To: Multiple recipients of list ORACLE-L
> 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'
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: VIVEK_SHARMA
> INET: VIVEK_SHARMA_at_infy.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Oct 11 2000 - 14:05:14 CDT
