ORA-01172: recovery of thread 1 stuck at block 3024 of file 19
ERROR :
SQL> startup
ORACLE instance started.
Total System Global Area 2.1475E+10 bytes
Fixed Size 12170960 bytes
Variable Size 3019901232 bytes
Database Buffers 1.8388E+10 bytes
Redo Buffers 54935552 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 3024 of file 19
ORA-01151: use media recovery to recover block, restore backup if needed
Cause:
This error usually means that blocks of file 19 are corrupted, In this case we need to recover file 19.
SOLUTION :-
We need to recover all of corrupted block by using data file recovery or Database recovery.
In my case I have recover datafile 19.
SQL> recover datafile 19;
Media recovery complete.
SQL> alter database open;
Database altered.
SQL> select name,OPEN_MODE from v$database;
NAME OPEN_MODE
--------- --------------------
TEST READ WRITE
Comments