ORA-01172: recovery of thread 1 stuck at block 224 of file 3

ORA-01172: recovery of thread 1 stuck at block 224 of file 3

ORA-01151: use media recovery to recover block, restore backup if needed


When starting the database I got error above

SQL> startup
ORACLE instance started.

Total System Global Area  417546240 bytes
Fixed Size                  2227080 bytes
Variable Size             310379640 bytes
Database Buffers          100663296 bytes
Redo Buffers                4276224 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 224 of file 3
ORA-01151: use media recovery to recover block, restore backup if needed

Solution - According to the error you should contact oracle support, but this is what I did

Find name of the file having problem

select name,status,enabled from v$datafile where file#=3;

/u01/app/oracle/oradata/XE/undotbs1.dbf


SQL> recover datafile 3;
Media recovery complete.

SQL> alter database open;

Database altered.