RE: Drop Tablespace failing

From: <antonio.belloni_at_hstern.com.br>
Date: Tue, 17 Oct 2000 08:33:54 -0300
Message-Id: <10652.119432@fatcity.com>

Hi,

- Shutdown your database;
- Alter your init.ora and modify the rollback segment parameter to :=

_offline_rollback_segments =3D (r01,r02......rn)

3) - Start your database again and drop the rollback segment;
4) - Drop the tablespace;
5) - Shutdown the DB again and change the rollback segment parameter to=

its
default. Don=B4t forget to change the list of rollback segments and omi= t the
one that you=B4ve droped.

HIH,
Antonio Belloni

Oliver Artelt <oli_at_md.transnet.de>@fatcity.com on 11/10/2000 19:00:45

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: RE: Drop Tablespace failing

can you simply drop that rollback segment?

oli.

On Mit, 11 Okt 2000, VIVEK_SHARMA wrote:
> 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 li=
ke
> > File size Differs for "/in1backup2/db3/bm2f/migr_roll_1_bm2f.dbf" a=
t
O.S.
> > & Database Levels
> > 4) Dropped the Datafile as it Contains Only one Rollback Segment wh=
ich
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 List=

s


> --------------------------------------------------------------------

> 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).

--
---

Oliver Artelt, System- und Datenbankadministration
---------------------------------------------------------------
  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
   email: oli@cubeoffice.de # web: http://www.cubeoffice.de
---------------------------------------------------------------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oliver Artelt
  INET: oli_at_md.transnet.de

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

Received on Tue Oct 17 2000 - 06:33:54 CDT