| |
GeekInterview.com > Interview Questions > Oracle > Backup and Recovery
| Print | |
Question: Corrupted Archieve Logs
Answer: There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how? |
| September 09, 2009 05:05:24 |
#4 |
| Kamran Agayev A. |
Member Since: September 2009 Total Comments: 2 |
RE: Corrupted Archieve Logs
|
In this situation you're not able to recover the database. Of course, it can be done by using nonsupported and nondocumented parameter "_ALLOW_RESETLOGS_CORRUPTED" but you HAVE NOT to use it without Oracle Support's suggestion
If your database is running, take a whole backup, delete all archived redo log files and start creating archived redo log files again |
| |
Back To Question | |
