I don't think he would need it. After he put the datafile online, he =
can
consider which path to choose. However, you should take care of
_corrupted_rollback_segments and _offline_rollback_segments, because =
you
could drop rollback segments and corrupt your database.
Regards.
> -----Mensaje original-----
> De: Dash, Saroj (CAP,CEF) [SMTP:Saroj.Dash_at_gecapital.com]
> Enviado el: martes 9 de enero de 2001 11:21
> Para: Multiple recipients of list ORACLE-L
> Asunto: ?: Rollback segments in "RECOVER" status
>=20
> Use the hidden paramerter for the corrupted rollbacksegment in =
init.ora.
>=20
> _corrupted_rollback_segments=3D(r01,r02......;
>=20
> then drop offline the tablespace.
> drop the rollback segment.
> recreate the rollback segment.
>=20
> I think it will work.
>=20
>=20
> -----OE=B3'=CCf=81fbfZ=81[fW-----
> =8D=B7=8Fo=90l: Trassens, Christian [mailto:CTrassens_at_uni2.es]
> '-=90M"=FAZz: Tuesday, January 09, 2001 PM 06:15
> ^=B6=90=E6: Multiple recipients of list ORACLE-L
> OE=8F-=BC: RE: Rollback segments in "RECOVER" status
>=20
> First of all, you must never put a datafile of rollback tablespace =
offline
> when the database is up and running. You should put the rollback =
segment
> offline:
>=20
> alter rollback segment <rbs01> offline; ( try not to use STORAGE =
MANAGER
> or
> Enterprise Manager products )
>=20
> Now for your problem issue from svrmgr23 a recover datafile
> 'E:\ORANT\DATABASE\RBS2ORCL.ORA' ( CROSS YOUR FINGERS(*) ) and then =
alter
> database datafile 'E:\ORANT\DATABASE\RBS2ORCL.ORA' online;. Probably =
after
> this the rollbacks should be online because it isn't an usually case =
of
> NEEDS RECOVERY. However take a look of the state of those issuing a =
select
> segment_name,status from sys.dba_rollback_segs where segment_name in
> =
('RB3','RB4','RB5','RB6','RB7','RB8','RB9','RB10','RB11','RB12','RB13','=
RB
> 14
> ','RB15','RB16');
>=20
> (*) Because of the archive mode of your database. If you have it in
> archivelog with archives, NO PROBLEM. However if it an NOARCHIVELOG
> database, you should pray just to expect that the information is in =
the
> redo
> logs.
>=20
> Regards and good luck.
>=20
>=20
>=20
> > -----Mensaje original-----
> > De: Andersen, Wayne A [SMTP:WayneAAndersen_at_Eaton.com]
> > Enviado el: lunes 8 de enero de 2001 20:46
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Rollback segments in "RECOVER" status
> >=20
> > Hi all,
> >=20
> > I'm running Oracle 7.3 on a Windows NT platform.
> >=20
> > Recently I was trying to increase the size of the roll back =
segments to
> > make
> > room for a large transaction. Using Oracle Storage Manager, I set =
a
> > datafile offline thinking it would go offline when any transactions =
that
> > might be using it finished. Instead it went in to "RECOVER" mode.
> >=20
> > My users are now getting "ORA-00376 file 15 cannot be read at this
> time."
> > and "ORA-01110 data file 15: E:\ORANT\DATABASE\RBS2ORCL.ORA."
> >=20
> > Rollback segments RB3 through RB16 show a status of "NEEDS =
RECOVERY". =20
> >=20
> > I was even going to drop the database, re-create it, and re-import =
the
> > data,
> > but it won't even let me do that!
> >=20
> > Anyone have an idea of how I can get out of this problem?
> >=20
> > Thanks,
> >=20
> > Wayne Andersen=20
> > --=20
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --=20
> > Author: Andersen, Wayne A
> > INET: WayneAAndersen_at_Eaton.com
> >=20
> > 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).
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Trassens, Christian
> INET: CTrassens_at_uni2.es
>=20
> 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).
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Dash, Saroj (CAP,CEF)
> INET: Saroj.Dash_at_gecapital.com
>=20
> 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
Received on Tue Jan 09 2001 - 07:23:43 CST
