ora-1172 on personal oracle - crashed database.

Hi all,

I was working on the database when suddenly I had a voltage breakdown, when the computer restarted and I tried opening the DB I got the ora-1172 without the required details such as: thread num, block num, and file name.

ORA-01172 recovery of thread num stuck at block num of file name

Cause: Crash recovery or instance recovery could not apply a change to a block because it was not the next change. This can happen if the block was corrupted and then repaired during recovery.

Action: Perform a RECOVER datafile for the file containing the block. If this does not resolve the problem, then restore the file from a backup and recover it again.

I tried using the Recovery Manager which asked me to start the database, a thing I can't do.

I already check for physical problems on the disk and the disk is ok.

I can restore from backup but I don't want to lose the data from the last backup...

Thanks in advance.

Yoav. Received on Tue Jun 06 2000 - 00:00:00 CDT