I am using Oracle 8.1.7 on win2000 AS, My database need media recovery,
But i haven't any backup.
I m in trouble bcoz the data is very important and i wanna recovery in urgent.
Database Errors are
ORA-01172 - Recovery of thread 1 stuck set at block 191919 of file 22.
ORA-01151 - Use media recovery to recover block, Restore backup if needed.
I have fixed minor corruption in a database where the required information was in the logfiles. You can try to do a manual database recovery and point to the log files when it asks for the rollback. If you have enough rollback in the log files you might be ok. Your database might not be as bad off as you think. Before you do a lot of experimenting a backup might be a good idea. Are you in archivelog mode? I guess after this experience you will be looking at daily exports and daily full backups as well as archivelog mode. You might also need to issue a recover statement against the affected datafile.