ORA-01172: recovery of thread 1 stuck at block 1340 of file 2
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.