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

SQL> startup
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 1288820 bytes
Variable Size 192939404 bytes
Database Buffers 402653184 bytes
Redo Buffers 2904064 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 4545 of file 1
ORA-01151: use media recovery to recover block, restore backup if needed
SQL>

Cause :
  There is block corruption in tablespace.

Solution :

 SQL> shutdown immediate;
SQL> startup mount;
SQL> recover database;
SQL> alter database open;

 

4 responses to “ORA-01151: use media recovery to recover block, restore backup if needed”

  1. thank you so much. it solved my problem…

    Like

  2. Anonymous

    Hi,Thank you so much.

    Like

  3. Thanks a lot… it solved my issue 🙂

    Like

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.