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
