Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!irazu.switch.ch!ezmp2.switch.ch!neupina.switch.ch!switch.ch!newscore.univie.ac.at!aconews-feed.univie.ac.at!143.50.206.163.MISMATCH!skirner.kfunigraz.ac.at!not-for-mail
From: "Clemens Keil" <clemens.keil@meduni-graz.at>
Newsgroups: comp.databases.oracle.server
Subject: Re: Rollback Segment
Date: Mon, 19 Apr 2004 22:38:58 +0200
Organization: Karl-Franzens-Universitaet Graz
Lines: 41
Message-ID: <c618n1$25g$1@skirner.kfunigraz.ac.at>
References: <c615m0$1vq$1@skirner.kfunigraz.ac.at> <2rWgc.35035$Gp4.533722@news20.bellglobal.com>
NNTP-Posting-Host: klinik015.kfunigraz.ac.at
X-Trace: skirner.kfunigraz.ac.at 1082402337 2224 143.50.41.15 (19 Apr 2004 19:18:57 GMT)
X-Complaints-To: postmaster@kfunigraz.ac.at
NNTP-Posting-Date: Mon, 19 Apr 2004 19:18:57 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:259815

Thank you, I found it.
It worked. The database is alive again.
cu


"G Dahler" <yellow-shark@spamex.com> schrieb im Newsbeitrag
news:2rWgc.35035$Gp4.533722@news20.bellglobal.com...
>
> "Clemens Keil" <clemens.keil@meduni-graz.at> a écrit dans le message de
> news:c615m0$1vq$1@skirner.kfunigraz.ac.at...
> > Hello All,
> > I have an Oracle 8i Database. Within the Datafile where I have had 10
> > Rollback-Segments I have taken one offline and have deleted it to save
> disk
> > space. Now it seems that I cannot mount the database any more. I can
> connect
> > in the svrmgr30-console but when I want to startup the database I get
the
> > message
> > "database mounted." and in the next line
> > "ORA-01534:  rollback segment 'RB2' does not exist"
> >
> > And I do not get any access to the db neither through EnterpriseManager,
> > StorageManager nor through SQL-Worksheet.
> >
> > Any idea?
> >
>
> You probably have something like:
>
> rollback_segments = (R01, R02, R...) in you initxxx.ora
>
> You probably forgot to comment it out and only leave your actual rollback
> segments there.
>
> Been there, done that !
>
>
>