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.

Crash recovery or instance recovery could not apply a change to a block because it was not the next change. 
This can happen if the block was corrupted and then repaired during recovery.

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


No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...