4 Replies Latest reply: Sep 17, 2010 2:19 AM by 644649 RSS

    ORA-01172: recovery of thread 1 stuck at block 1340 of file 2

    user1077137
      Database Version: Oracle 10G rel 10.02
      OS:- Windows XP SP2.

      Scenario:- Trying to open the database .
      Error:-

      SQL> startup open;
      ORACLE instance started.

      Total System Global Area 272629760 bytes
      Fixed Size 1248476 bytes
      Variable Size 100664100 bytes
      Database Buffers 163577856 bytes
      Redo Buffers 7139328 bytes
      Database mounted.
      ORA-01172: recovery of thread 1 stuck at block 1340 of file 2
      ORA-01151: use media recovery to recover block, restore backup if needed



      Please advise.