Re: Re[2]: How can I get my DB back if I lost one of my

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Tue, 14 Aug 2001 11:13:02 -0700
Message-ID: <F001.0036A282.20010814104337@fatcity.com>

rollback segs will be used in INSTANCE recovery... not in media recovery

shutdown abort does not flush anything from the SGA, remember? it forces instance recovery.

if you do a clean shutdown, you will not need the rollback segments.

>From: "JOE TESTA" <JTESTA_at_longaberger.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Re[2]: How can I get my DB back if I lost one of my
>Date: Tue, 14 Aug 2001 09:40:53 -0800
>
>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
>the
>online redo logs. When a DB shuts down the rollback segments are emptied
>out
>either because the transactions have been rolled back or committed. Once
>you
>start the recovery process the rollback segments are no longer required as
>the
>data therein is in the on-line redo logs.
>
>Dick Goulet
>
>____________________Reply Separator____________________
>Author: Riyaj_Shamsudeen_at_i2.com
>Date: 8/14/2001 6:41 AM
>
>Hermanto
> 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.
>
>Thanks
>Riyaj "Re-yas" Shamsudeen
>Certified Oracle DBA
>i2 technologies www.i2.com
>
>
>
>
>Hermanto P <hermanto_p_at_aprilasia.com>
>Sent by: root_at_fatcity.com
>08/14/01 03:35 AM
>Please 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
>rollback
>segment (rb
>
>
>Hi 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: http://www.orafaq.com
>--
>Author: Hermanto P
> INET: hermanto_p_at_aprilasia.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).
>
>
>
>
> Hermanto
>         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.
> 
> Thanks 
>Riyaj "Re-yas" Shamsudeen 
>Certified Oracle DBA 
>i2 technologies   www.i2.com
> 
> 
> 
><table width=100%>
><tr valign=top>
><td>
><td>Hermanto P
><hermanto_p_at_aprilasia.com>
> Sent by: root_at_fatcity.com
>08/14/01 03:35 AM
> Please respond to ORACLE-L
> 
><td>        
>         To:  
> 
>   Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>         cc:  
> 
>   
>          
>   How can I get my DB back if I lost one of my rollback
>segment (rb</table>
> 
> 
> Hi 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: http://www.orafaq.com 
>-- 
>Author: Hermanto P 
> INET: hermanto_p_at_aprilasia.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). 
>
> 
> 
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: dgoulet_at_vicr.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).

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: carmichr_at_hotmail.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 Tue Aug 14 2001 - 13:13:02 CDT