Oracle OERR: ORA-1545 “rollback segment ‘%s’ specified not available” Reference Note

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com


oerr ora 1545
01545, 00000, "rollback segment '%s' specified not available"
// *Cause: Either:
// 1) An attempt was made to bring a rollback segment online that is
// unavailable during startup; for example, the rollback segment
// is in an offline tablespace.
// 2) An attempt was made to bring a rollback segment online that is
// already online. This is because the rollback segment is
// specified twice in the ROLLBACK_SEGMENTS parameter in the
// initialization parameter file or the rollback segment is already
// online by another instance.
// 3) An attempt was made to drop a rollback segment that is
// currently online.
// 4) An attempt was made to alter a rollback segment that is
// currently online to use unlimited extents.
// 5) An attempt was made to online a rollback segment that is
// corrupted. This is because the rollback is specified in
// _corrupted_rollback_segments parameter in initialization
// parameter file.
// *Action: Either:
// 1) Make the rollback segment available; for example, bring an
// offline tablespace online.
// 2) Remove the name from the ROLLBACK_SEGMENTS parameter if the name
// is a duplicate or if another instance has already acquired the
// rollback segment.
// 3) Bring the rollback segment offline first. This may involve
// waiting for the active transactions to finish, or, if the
// rollback segment needs recovery, discover which errors are
// holding up the rolling back of the transactions and take
// appropriate actions.
// 4) Same as 3).
// 5) Remove the name from the _corrupted_rollback_segments parameter.

目标

这是一个简短的参考指南,展示数据库错误”ORA-1545″的含义,包括错误文本、来自消息文件的从9.2开始每个数据库版本的原因和对策,以及搜索链接和与该错误相关的任何数据库bug的详细信息。

范围

本指南旨在帮助普通观众,作为检查“ORA- 1545”含义的一个出发点。它没有给出有关错误的详细信息,也没有给出低于9.2版本的错误消息文本。

详细信息

Error Text, Cause and Action from Message File/s for ORA-01545

Versions 9.2, 10.1, 10.2, 11.1, 11.2, 12.1

错误: ORA-01545 rollback segment ‘%s’ specified not available
—————————————————————————
原因: Either: 1)试图使在启动过程中不可用的回滚段联机;

例如回滚段位于一个脱机表空间。

for example, the rollback segment is in
an offline tablespace. 2) An attempt was made to bring a rollback
segment online that is already online. This is because the rollback
segment is specified twice in the ROLLBACK_SEGMENTS parameter in the
initialization parameter file or the rollback segment is already online
by another instance. 3) An attempt was made to drop a rollback segment
that is currently online. 4) An attempt was made to alter a rollback
segment that is currently online to use unlimited extents. 5) An
attempt was made to online a rollback segment that is corrupted. This
is because the rollback is specified in _corrupted_rollback_segments
parameter in initialization parameter file.
Action: Either: 1) Make the rollback segment available; for example, bring an
offline tablespace online. 2) Remove the name from the
ROLLBACK_SEGMENTS parameter if the name is a duplicate or if another
instance has already acquired the rollback segment. 3) Bring the
rollback segment offline first. This may involve waiting for the active
transactions to finish, or, if the rollback segment needs recovery,
discover which errors are holding up the rolling back of the
transactions and take appropriate actions. 4) Same as 3). 5) Remove the
name from the _corrupted_rollback_segments parameter.
Support Notes for ORA-01545

 

Support Notes for ORA-01545

  • If you tried to DROP an online rollback segment take the rollback segment offline first.
  • If using PUBLIC rollback segments you may have to set the ratio: “transactions_per_rollback_segment / transactions” so that you only pickup the required number of PUBLIC rollback segments. Eg: setting the ratio to come out at one will ensure you pick up NO public rollback segments.

Search Links for ORA-01545

The links below can be used to locate ORA-1545 in the documentation, and to search for documents that give more information about the error.

Database Bugs Related to ORA-01545

Errors are usually due to usage, application or configuration issues but in some cases they may be caused by a bug issue. This section lists any database bugs that have been linked to error “ORA-1545” .

There are currently no documented database bugs linked to “ORA-1545” .

 

Comment

*

沪ICP备14014813号

沪公网安备 31010802001379号