Re: startup error: ORA-01534: rollback segment 'R01' doesn't exist

Your init.ora file includes a statement specifying the rollback segments to use. In includes the id RO1, but the segment doesn't exist.

Edit the init.ora to remove the reference and you should be ok.

In article <357C042A.85442FD_at_merck.com>,   "Kevin C. Austin" <kevin_austin_at_merck.com> wrote:
>
> On startup, I get the following error:
>
> $./svrmgrl
>
> Oracle Server Manager Release 2.3.3.0.0 - Production
>
> Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
>
> Oracle7 Server Release 7.3.3.0.0 - Production Release
> With the distributed, replication and Spatial Data options
> PL/SQL Release 2.3.3.0.0 - Production
>
> SVRMGR> connect internal
> Connected to an idle instance.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 4568736 bytes
> Fixed Size 57136 bytes
> Variable Size 4093808 bytes
> Database Buffers 409600 bytes
> Redo Buffers 8192 bytes
> Database mounted.
> ORA-01534: rollback segment 'R01' doesn't exist
>
> And then the database doesn't actually start.
>
> What is causing this? Any suggestions for how to correct it?
>
> This is a 7.3.3 instance running on an SGI O2 running IRIX 6.3
>
> Thanks,
> Kevin
>
> The contents of this message express only the sender's opinion.
> This message does not necessarily reflect the policy or views of
> my employer, Merck & Co., Inc. All responsibility for the statements
> made in this Usenet posting resides solely and completely with the
> sender.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 08 1998 - 13:55:12 CDT