| |
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? |
| July 07, 2008 05:28:34 |
#2 |
| g.mrunalini |
Member Since: February 2008 Total Comments: 8 |
RE: Corrupted Archieve Logs
|
| If the archive log which was missed has been still exists in the online redo log file. That means the log sequence number for that file in the online redo log files doesnt get overwritten at the time we plan to do recovery, then switch that redo log file again so that we will get the corrupted log file back. |
| |
Back To Question | |
