Re: URGENT ! Error starting when unlimited extents for roll back segment

From: <jmvegalerin_at_my-deja.com>
Date: Fri, 13 Aug 1999 10:21:38 GMT
Message-ID: <7p0rjf$lvu$1@nnrp1.deja.com>

In article <7oug9k$1kg$1_at_nnrp1.deja.com>,   marko.plevel_at_rd.iskraemeco.si wrote:
> Hi !
>
> What has happened :
> -I had a very large transaction and therefore had to increase
> the number ob rollback segment extents number to over 121 ( default
> maximum for 7.3.3 ). To do this Oracle required the
> unlimited_rollback_segments parameter to be set to TRUE. That's what I
> did and everything worked.
> -One night there was no power. When the computer rebooted the Oracle
> server didn't start.
>
> When I try to open the database I get an error saying
> that rollback segment (1) has unlimited extents and open fails.
> I don't remember the exact error number ORA 1682.
>
> I tried with "recover database" and it reported, it's recovered.
> I tried opening db again ( alter database open )
> then I got these three errors ORA 0704, ORA 0604, ORA 0955.
>
> I have no backup.
> What are my options to recover data.
>
> Please, if possible e_mail me at Marko.Plevel_at_rd.iskraemeco.si
>
> Thanx,
> Marko
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Hello marko

I receive the "ORA-01682: rollback segment (1) has unlimited extents" when i have rollback segments with "maxextents unlimited" and someone has change de init.ora parameter :
....
#unlimited_rollback_segments = TRUE
...

Are you sure that you have this parameter to true?

SVRMGRL> connect internal
Connected.
SVRMGRL> startup nomount

Total System Global Area       4488440 bytes
Fixed Size                       38984 bytes
Variable Size                  4031664 bytes
Database Buffers                409600 bytes
Redo Buffers                      8192 bytes
SVRMGR> show parameter unlimited_rollback_segments
NAME                                TYPE    VALUE
----------------------------------- ------- --------------------------
unlimited_rollback_segments         boolean TRUE

SVRMGR> Hope this will help you.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 13 1999 - 05:21:38 CDT