Page 1 of 1

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

Posted:
by 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.

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

Posted:
by venkat
Hi,

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


Regard's
venkat(VIT)
9866277876

Thanks

Posted:
by arif
Thanks venkat for ur reply, but couldnt recover even.

Thanks

Posted:
by arif
Thanks venkat for ur reply, but couldnt recover even.

Thanks

Posted:
by arif
Thanks venkat for ur reply, but couldnt recover even.