ORA-10564 Tablespace UNDOTBS1 ORA-01110 ORA-10560

ORA-10564 Tablespace UNDOTBS1 ORA-01110 ORA-10560

Applies to:

            Oracle Enterprise Linux – Version: 7

            Oracle EBS R12

Description:

            After abnormal shutdown of server we face the problem “ORA-10564 Tablespace UNDOTBS1 ORA-01110 data file 7 UNDOTBS01.DBF ORA-10560 block type KTU UNDO BLOCK”. I have restarted all the services of database but the problem is same. I have also restarted the whole machine/server but still the same issue.

Solution:

            After some research I found that recreate the undo tablespace to resolve the issue.

Following the steps to resolve the above issue:

1-      Connect / as sysdba

2-      Create undo tablespace UNDOTBS2 datafile ‘/u01/oracle/oradata/undotbs02.dbf’ size=1G;

3-      Alter system set undo_tablespace = UNDOTBS2;

4-      Shutdown immediate

5-      startup

6-      Drop tablespace UNDOTBS1 including contents and datafiles;

Database is working fine now.

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ