| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Use of corrupted_rollback_segments parameter
These parameters should be used ONLY on the instructions of Oracle Support
-- yes they can further corrupt your database.
They are used to force the database open when there are rollback segments that are in a corrupted state.. and Oracle cannot do the instance recovery necessary. Because they basically throw away the data in those rollback segments, it is possible for your database to be left (at best) in an inconsistent state.
If you have to use them... it should be done to force open the database so that you can export the data prior to rebuilding the database only. Do not continue to use the database once you have had to force it open....
it's like prying open your front door with a crowbar because you locked your keys in the house and breaking the lock... and then continuing to use the door without replacing the lock.... you ain't gonna like what you find inside one day. :)
Rachel
>From: "Balasubramanian .M" <sbala_at_hclinsys.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Use of corrupted_rollback_segments parameter
>Date: Thu, 22 Jun 2000 23:54:52 -0800
>
>Dear all,
>
>There are undocumented parameter called corrupted_rollback_segments and
>offline_corrupted_rollback_segments in oracle.
>What is the use of these parameters ? Under what circumstances i should use
>those parameters to make the database up ?
>I heard that if we use improperly it may recorrupt the database. Is it true
>?
>
>Can any one explain this in detail ?
>
>Rgds,
>bala
>--
>Author: Balasubramanian .M
> INET: sbala_at_hclinsys.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).
 |
 |