Re: Please help, I'm an idiot

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 22 Feb 2000 16:28:42 GMT
Message-ID: <38bab192.7542345@netnews.worldnet.att.net>

You may be able to resolve this by editing your init.ora file. Does your startup error look like this:

SVRMGR> startup
ORACLE instance started.

Total System Global Area                         36437964
bytes
Fixed Size                                          65484
bytes
Variable Size                                    19521536
bytes
Database Buffers                                 16777216
bytes
Redo Buffers                                        73728

bytes
Database mounted.
ORA-01534: rollback segment 'RBX' doesn't exist SVRMGR> If so, then you probably have a line in your init.ora file that looks like this:

rollback_segments = (rb1,rb2,rb3,rbx)

Delete the name of the offending rollback segment (in this case rbx) from the rollback_segments parameter in your init file. Shutdown and restart the instance. It should open this time. If you like, you can then recreate the rollback segment that you dropped.

regards,

Jonathan

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Mon, 21 Feb 2000 09:39:11 -0800, Greg Akins <gakinsNOgaSPAM_at_gatewayhealthplan.com.invalid> 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!
Received on Tue Feb 22 2000 - 10:28:42 CST