Re: ORA-01545:rollback segment specified not available

.. and before doing that, rem-out the rollback_segments entry to make sure your INIT.ORA
file isn't trying to bring the offending rollback segment online.

Graham

Graham C Thornton wrote in message <7ga9bi$ap11_at_news.abbott.com>...
>Andrea,
>
>Add this to your INIT.ORA file:
>
>_offline_rollback_segments = ( <rollback name1>,<rollback name2> )
>
>to force the rollback segment offline.
>
>HTH
>
>Graham
>
>--
>Empowerment - delegating the responsibility but not the authority.
>-------------------------------
>
>Opinions expressed do not necessarily reflect those of Abbott Laboratories.
>
>andrea_johnson_at_wolfe.net wrote in message
><7ga652$r4k$1_at_nnrp1.dejanews.com>...
>>How can I put the tablespace including the rollback segement back online
>(it's
>>offline now) if I can't open the database because of the error?
>>
>>Startup mounts, but won't open because of the unavailable rollback
segment.
>>After that, alter database open results in: ORA-00704 - bootstrap process
>>failure/ORA-00705 - inconsistant state during startup: shutdown the
>instance,
>>then restart it. (shutdown/restart doesn't help)
>>
>>Help?
>>
>>-----------== Posted via Deja News, The Discussion Network ==----------
>>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
Received on Thu Apr 29 1999 - 13:55:19 CDT