Skip to main content

ORA-30013: undo tablespace 'UNDOTBS1' is currently in use



ORA-30013 is the error reported when the specified Undo tablespace is in use. In other words, this implies there are some background processes still using the undo tablespace.
 This error can be reported in both space management or transaction management.

 Error ORA-30013 reported while dropping the Undo tablespace.

 In this case, the Undo tablespace is used by other active transactions, leading to the error. In such cases, we have to wait until the transactions are committed or rolled back before dropping the Undo tablespace. This situation is similar to that of the ORA-1548 case.

Error ORA-30013 reported while bringing up the database.

 This happens for RAC databases while the undo tablespace mentioned for an instance is already in use. The solution will be to set separate Undo tablespace for all instances.
 Since undo_tablespace is an instance local parameter, we have to ensure that the "Alter system set undo_tablespace" is being invoked on a different instance than the one on which the "Alter system" command was issued.
  
 alter system set undo_tablespace= <undo tablespace name> sid='<instance name>'; 

Diagnostic Information to be Collected While Raising a Service Request.


If the issue persists, please raise a Service Request with the following information
a. Provide the complete error message reported along with the trace files generated.
b. Provide the following outputs:


Select segment_name,status,tablespace_name from dba_rollback_segs where status not in ('ONLINE','OFFLINE') ;
select KTUXEUSN, KTUXESLT, KTUXESQN, KTUXESTA, KTUXECFL, KTUXESIZ
from x$ktuxe
where KTUXESTA='ACTIVE' and KTUXECFL='DEAD';
SELECT LOCAL_TRAN_ID,GLOBAL_TRAN_ID,STATE,MIXED,COMMIT# FROM DBA_2PC_PENDING;

SELECT LOCAL_TRAN_ID,IN_OUT,DATABASE,INTERFACE FROM dba_2pc_neighbors;
show parameter undo

Comments

Post a Comment

Popular posts from this blog

TOP 10 VENOMOUS SNAKES IN THE WORLD

            It’s important to point out here that there’s a difference between   venomous snakes   and   poisonous snakes . Venomous here implies that something is capable of injecting someone or something with Venom, while poisonous implies that it is capable of harming you by merely touching or eating it.    Now let see the rating from 10th to 1st place -  10. Rattle Snake         The Rattle Snake is a sub-family of the pit vipers, it has a very unique tail that makes it easy to be identified. At the end of it’s tail is located the rattle which makes so much noise when shaken, that’s where the name “rattle snake” comes from. Large number of it can be found in America particularly at the south, western part of United States and Mexico. One Striking feature of rattle snake that they possessed from the pit vipers families is that they have two organs that...
Post a Comment
Read more
Alexander Graham Bell, the teacher of the deaf and his deaf wife Alexander Graham Bell. Alexander Graham Bell  (3 March 1847 – 2 August 1922) was an eminent scientist, inventor and innovator who is widely credited with inventing the first practical telephone. Bell was deeply affected by his mother's gradual deafness, (she began to lose her hearing when he was 12) and learned a manual finger language so he could sit at her side and tap out silently the conversations swirling around the family parlour. He also developed a technique of speaking in clear, modulated tones directly into his mother's forehead wherein she would hear him with reasonable clarity. Bell's preoccupation with his mother's deafness led him to study Acoustics (study of all mechanical waves in gases, liquids, and solids including vibration, sound, ultrasound and infrasound). Alexander Graham Bell, his wife Mabel Gardiner Hubbard, and their daughters Elsie (left) an...
Post a Comment
Read more