Re: Rollback segments take on/offline randomly

Vincent,

This is problably because the instance was shut down and started again. You have to add your new rollback segments to the INIT.ORA file (or to be more precise: the PFILE used in the STARTUP command; if no PFILE was defined in the startup command, it's the INIT.ORA). Add the names of your rollback segments to this file, like:

ROLLBACK_SEGMENTS = ( r1,r2...,rn)

Roel
Vincent GRENET <vincent.grenet_at_free.fr> wrote in message news:rWPF3.840$jg4.2619488_at_nnrp3.proxad.net...
> Hi all.
>
> The rollback segments in the database are taken online or offline randomly
> by the server without any manual action. Why is that ?
>
> I created the database with the installer which creates four rollback
> segments, I added 5 other rollback segments. I switched offline the
segments
> created by the installer (I could have dropped them but I didn't.) and
> switched online mine. After a running the applications for a while, I
check
> the segments in dba_rollback_segs, and 3 of my segments (allways the same)
> are taken offline, and the 4 segments created by the installer are brought
> back online.
>
> Any help welcome.
>
> Vincent
>
>
Received on Wed Sep 22 1999 - 15:52:55 CDT