Re: Can't bring rollback segs online after startup

From: Kenny Gump <kgump_at_mylanlabs.com.nospam>
Date: Thu, 1 Jul 1999 06:29:49 -0400
Message-ID: <377b4346.0@news.mountain.net>

You need to add the following line to your init.ora file:

rollback_segments=(r01, r02, r03, r04)

This will bring them online when the database is started. The order you list them in is the order in which they will come online.

Kenny Gump
OCP 7.3 DBA WCK wrote in message <377AF930.851E33F6_at_pacific.net.sg>...
>I created a new database with 4x rollback segments in a separate
>rollback datafile. But when I restart it, all the rollback segs, except
>the system rollback segs, came up as OFFLINE. I followed the book,
>ORacle for Unix, closely but doesn't seems to work. Any adivce will be
>appreciated.
>
>WCK
>
Received on Thu Jul 01 1999 - 05:29:49 CDT