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

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
>
>

If you are using private rollback segments rather than public have you tred removing the offending segment(s) from the init.ora? Try that, bring it up, then see if you drop and re-create the segments. Since it appears you crashed, i.e., power loss you will probably need to access the segments so you will have to use the underbar init.ora parameter, _rollback_segment_offline, to start your database. You will have to contact Oracle customer support to get the correct name of the current parameter for your version as I pulled this one from memory. Oracle support provided us with the parameter to get around a corrupted rollback segment problem a couple of versions past. The problem with using the parameter is that you must then drop and recreate the rollback segment which may result in some inconsistent data if a rollback of an incomplete transaction is necessary. Then again the recovery that Oracle said worked may have taken care of that problem or no problem.

Speaking with Oracle support, you probably should call this in to find out if it is a bug. I thought I read in one section of one of the mauals that you should not assign unlimited to rollback segments, but I am sure while reading about parallel query that the manual said to use unlimited on rollbacks because the different parts of the parallel dml statement could be assigned to different rbs segments. Anyone outthere know the correct answer.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 12 1999 - 12:39:06 CDT