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: Please help, I'm an idiot

Re: Please help, I'm an idiot

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 21 Feb 2000 17:56:48 +0800
Message-ID: <38B10BE0.33A4@yahoo.com>


Greg Akins wrote:
>
> Hi,
>
> I just started messing around with Oracle8 on a Linux box. I've
> set up a couple databases before, but really on have some
> minimal DBA skills.
>
> This morning I dropped a rollback segment and when I tried to
> restart the database it bombed because it couldn't find the
> segment.
>
> What should I do:
>
> 1. I don't think I can create the rollback segment, since the
> database won't get any farther than 'MOUNTED'.
> 2. Can I edit the startup scripts to get the database to stop
> looking for those segments.
> 3. Should I just recreate the database and start over.
>
> I didn't establish any backup/recovery scheme. However, I also
> don't have much to lose.
>
> Can anybody point me in the right direction.
>
> -greg
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!

It is probably listed in the init.ora parameter file for your database. Remove it from there and you should be ok.

HTH
--



Connor McDonald
http://www.oracledba.co.uk

"Beta, n: Latin for 'still does not work'" Received on Mon Feb 21 2000 - 03:56:48 CST

Original text of this message

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