Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Drop Tablespace failing

Drop Tablespace failing

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
Date: Wed, 11 Oct 2000 23:44:01 +0530
Message-Id: <10646.118993@fatcity.com>


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 - 13:14:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US