Ask Maclean

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

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

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

服务热线 ： 13764045638 QQ号:47079569 邮箱：[email protected]



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







 



	







	
	

	

	
	

		
		

			
			

				
				

					Posted				

				

				


				
				

					in				

				

				
			

			

			
			

				
				

					by				

				

				
mac

			

			
		

		

		
		

			
			

				
				

					Tags:				

				

				
			

			
		

		
	

	






	



	
	

		
		
Comments

		

		

		

		

		

		
Leave a Reply 
Your email address will not be published. Required fields are marked *