Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't bring rollback segs online after startup

Re: Can't bring rollback segs online after startup

From: Markus Korn <markus.korn_at_at.siemens.de>
Date: Thu, 01 Jul 1999 07:57:58 +0200
Message-ID: <377B0366.E19748CE@at.siemens.de>


take a look in your $ORACLE_HOME/dbs/initSID.ora is there a entry like:

rollback_segments=(r01,r02,r03.....)

if not, add it and restart

MfG Markus

WCK wrote:
>
> 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 - 00:57:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US