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

[arif]

Hi, Rashed Sir/Mr. Pavan/Mr. Javed/All

I am not able to start the sap application as dispatcher is abrubptly stopped. This is because db is not up and running. I tried starting db thru sapdba it responded with fallowing error:

ORA-01172: recovery of thread 1 stuck at block 35890 of file 23

Can any one pls help me to solve this issue. Thanks in advance.

[venkat]

Hi,

here data file inconsistancy in database, so alter the database(recover the datafile)


Regard's
venkat(VIT)
9866277876

[arif]

Thanks venkat for ur reply, but couldnt recover even.

[arif]

Thanks venkat for ur reply, but couldnt recover even.

[arif]

Thanks venkat for ur reply, but couldnt recover even.