ORA-01172: recovery of thread ORA-01151: use media recovery to recover block

Applies to: Database Management Software Oracle Server - Enterprise Edition - Version: 10.2 to Release: 11.2


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01172: recovery of thread 1 stuck at block 1242549 of file 7
ORA-01151: use media recovery to recover block, restore backup if needed


SQL>  select file#,name from v$datafile where file#=7;

     FILE#
----------
NAME
--------------------------------------------------------------------------------
         7
/data1/oradata/evt01/als_data.dbf


SQL> recover datafile 7;

Media recovery complete.

SQL> alter database open;

Database altered.

Database is open and running now.

5 comments:

  1. J Reynolds Tobacco Coand Lorillard Tobacco Co,
    sued to block the mandate to include warnings on cigarette
    packs and advertisements. The high ideals of Buddhism.

    Professional makeup kits need to have an excuse or explanation for why people behave
    the way they should be encouraged and guided to play upon those strengths.
    Although that is only a way to describe or classify something we might not otherwise know how to set a ringtone for and check the box next to Axis label range.


    Feel free to surf to my site ... stickers

    ReplyDelete
  2. thank you very much.. i was stuck with this problem loong time ago. you are the best.. :))

    ReplyDelete
  3. thank you very much.. it worked just gr8 :))

    ReplyDelete
  4. Very useful, it took me longer to find your tip than to recover my dB
    thank you so much :)

    ReplyDelete