Re: ORA-01545:rollback segment specified not available

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 29 Apr 1999 13:24:10 -0700
Message-ID: <3728BFEA.C594C80A@us.oracle.com>

Andrea

If the tablespace is OK, but just offline, bring it online and you'll be OK. If it's not OK, comment out the rollback_segments parameter from the init.ora, start up, and create new rollback segments.

HTH. Pete

andrea_johnson_at_wolfe.net wrote:

> 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

Regards

Pete

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Thu Apr 29 1999 - 15:24:10 CDT