Printable View
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.
Please help me
Write command step by step
Thanx
well you said it, you dont have backup. How can you recover something without backup may I ask?
These statements are contradictory. How can the data be important if you don't back it up?Quote:
Originally posted by Jani
But i haven't any backup.
I m in trouble bcoz the data is very important and i wanna recovery in urgent.
1. Go homeQuote:
Write command step by step
2. update resume
3. post resume on monster.com, hotjobs.com, dbajobs.com, justoraclejobs.com, etc.
4. cross fingers
Is the db still up and running?
If yes, can you do an exp? Then, create a new db and imp the data into it.
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.
Good Luck.
Thats Great.