Well there must be something to the statement, back in v7
days, i did a shtdown abort, when i had a lrage RBS online(and not in the
init.ora file), well when i tried to bring the db backup, it refused until i put
the rbs in the init.ora file and oracle could then do recovery, short of an
instance crash or shutdown abort, i'm with you.
joe
>>> dgoulet_at_vicr.com 08/14/01 12:26PM
>>>Riyaj, Rollback segments are needed
for recovery? I think your confused with theonline redo logs.
When a DB shuts down the rollback segments are emptied outeither because the
transactions have been rolled back or committed. Once youstart the
recovery process the rollback segments are no longer required as thedata
therein is in the on-line redo logs.Dick
Goulet____________________Reply Separator____________________Author:
Riyaj_Shamsudeen_at_i2.comDate: 8/14/2001
6:41 AMHermanto Rollback
segment data files are *needed* for recovery. Rollback segments are the key
component for consistent media/instance recovery. If you lose any of the
rollback segment files and if any extents from that datafile are needed then
the database can not do the recovery consistently and will give you errors.
Is it the only data file associated with the rollback segment tablespace. If
that is the case, there will be extents from the rollback segments. If there
are no extents from the rollback segments then you could potentially offline
drop the datafile, do the media recovery and do open resetlogs. What errors
are you getting ? Stuck recovery ? Errors will tell you whether the recovery
process is looking for rollback segments or the data
file. Please contact Oracle
support if there are any rollback extents in this datafile.
_offline_rollback_segments and _corrupted_rollback_segments parameters can
be used to hard open the database. But DO expect data consistency errors. In
fact, only thing you should do is open this way, extract the data out and
import in to a new database. Contact Oracle Support before you do this since
there are serious consequences of doing this.ThanksRiyaj
"Re-yas" ShamsudeenCertified Oracle DBAi2 technologies
www.i2.comHermanto P
<hermanto_p_at_aprilasia.com>Sent by: root_at_fatcity.com08/14/01 03:35
AMPlease respond to
ORACLE-L
To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com> cc:
Subject: How can I get my DB back if I
lost one of my rollbacksegment (rbHi gurus,Recently, I have
forgotten to backup one of rollback segment file(rbs02.dbf).When I want
to restore..the db can not startup normally.Anyone can give me
advise..Thanks in advance.Warm regards,Hermanto-- Please
see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com-- Author:
Hermanto P INET: hermanto_p_at_aprilasia.comFat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).<br><font
size=2 face="sans-serif">Hermanto</font><br><font size=2
face="sans-serif"> Rollback
segmentdata files are *needed* for recovery. Rollback segments are the key
componentfor consistent media/instance recovery. If you lose any of the
rollback segmentfiles and if any extents from that datafile are needed then
the database can notdo the recovery consistently and will give you errors.
Is it the only data fileassociated with the rollback segment tablespace. If
that is the case, there willbe extents from the rollback segments. If there
are no extents from the rollbacksegments then you could potentially offline
drop the datafile, do the mediarecovery and do open resetlogs. What errors
are you getting ? Stuck recovery ?Errors will tell you whether the recovery
process is looking for rollbacksegments or the data
file.</font><br><font size=2 face="sans-serif">
Please contactOracle support if there are
any rollback extents in this datafile._offline_rollback_segments and
_corrupted_rollback_segments parameters can beused to hard open the
database. But DO expect data consistency errors. In fact,only thing you
should do is open this way, extract the data out and import in toa new
database. Contact Oracle Support before you do this since there areserious
consequences of doing this.</font><br><br><font
size=2 face="sans-serif">Thanks<br>Riyaj "Re-yas"
Shamsudeen<br>Certified Oracle DBA<br>i2 technologies
www.i2.com</font><br><br><br><table
width=100%><tr valign=top><td><td><font
size=1 face="sans-serif"><b>Hermanto
P<hermanto_p_at_aprilasia.com></b></font><br><font
size=1 face="sans-serif">Sent by:
root_at_fatcity.com</font><p><font size=1
face="sans-serif">08/14/01 03:35 AM</font><br><font size=1
face="sans-serif">Please respond to
ORACLE-L</font><br><td><font size=1
face="Arial">
</font><br><font size=1 face="sans-serif">
To:
Multiple recipients of list
ORACLE-L<ORACLE-L_at_fatcity.com></font><br><font
size=1 face="sans-serif"> cc:
</font><br><font size=1
face="sans-serif"> Subject:
How can I get my DB back if I lost
one of my rollbacksegment
(rb</font></table><br><br><br><font
size=2 face="Courier New">Hi gurus,<br>Recently, I have forgotten
to backup one of rollback segment
file<br>(rbs02.dbf).<br>When I want to restore..the db can
not startup normally.<br>Anyone can give me
advise..<br>Thanks in advance.<br><br>Warm
regards,<br>Hermanto<br>-- <br>Please see the
official ORACLE-L FAQ: <A
href="
http://www.orafaq.comhttp://www.orafaq.com<br>--
<br>Author: Hermanto P<br> INET:
hermanto_p_at_aprilasia.com<br><br>Fat City Network Services
-- (858) 538-5051 FAX:
(858)538-5051<br>San Diego, California
-- Public Internet access /Mailing
Lists<br>--------------------------------------------------------------------<br>To
REMOVE yourself from this mailing list, send an E-Mail message<br>to:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<br>the
message BODY, include a line containing: UNSUB ORACLE-L<br>(or the
name of mailing list you want to be removed from). You
may<br>also send the HELP command for other information (like
subscribing).<br></font><br><br>--
Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com-- Author:
INET: dgoulet_at_vicr.comFat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Tue Aug 14 2001 - 12:02:39 CDT