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

1. Are all of your rollback segments in one tablespace or are they distributed throughout several tablespaces?
2. Try commenting out the rollback segment list in initxxx.ora
3. What is your db_block_size? 121 extents is only the maximum if the block size is 2048. For 4096 it is 249.
4. If you need large rollback segments and you are running out of extents, create your rollback segments with larger extents.
5. Is your database in archivemode?
6. Why don't you have a backup?
7. When all else fails, call Oracle support.

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.
>
Received on Thu Aug 12 1999 - 09:04:39 CDT