Re: ignored duplicate rollback segment

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 24 Nov 2003 12:25:09 -0800
Message-ID: <1069705536.347636@yasure>

yls177 wrote:

> sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0311170617.1a2f78a1_at_posting.google.com>...
>

>>yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0311170018.353f8111_at_posting.google.com>...
>>
>>>i have this set of messages appearing regularly in my alert file. 
>>>
>>>Ignored duplicate rollback segment 12 in ROLLBACK_SEGMENTS parameter
>>>Ignored duplicate rollback segment 2 in ROLLBACK_SEGMENTS parameter
>>>Ignored duplicate rollback segment 13 in ROLLBACK_SEGMENTS parameter
>>>Ignored duplicate rollback segment 14 in ROLLBACK_SEGMENTS parameter
>>>Ignored duplicate rollback segment 15 in ROLLBACK_SEGMENTS parameter
>>
>>So verify the rollback_segments parameter in init.ora and discover you
>>do have duplicated segment names in it.
>>
>>Sybrand Bakker
>>Senior Oracle DBA

>
>
>
>
> in my initsid.ora, i had the following rollback segments
> rollback_segments = (PRS_1,PRS_10,PRS_11,PRS_12,PRS_13,PRS_14,PRS_2,PRS_3,PRS_4,PRS_5,PRS_6,PRS_7,PRS_8,PRS_9,
> prs_10, prs_11,
> prs_12, prs_13, prs_14, prs_15, prs_16, prs_17, prs_18, prs_19,
> prs_20, prs_21, prs_22, prs_23, prs_24, prs_25, prs_26, prs_27,
> prs_28, prs_29, prs_30)
>
> as you could see.... rollback segment, 12, 13, 14, are declared twice.
>
> but PRS_2, prs_15 are declared once.
>
> my understanding tells me that PRS_12 and prs_12 are the same,
> irregardless of big case?
>
> another question is what happens to PRS_2, prs_15. they are declared
> once only.

Get rid of the dups and bounce the database.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Nov 24 2003 - 14:25:09 CST