| |
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 09:33:10 |
#1 |
| raghavram |
Member Since: July 2008 Total Comments: 1 |
RE: Corrupted Archieve Logs
|
you can recover the datafiles byusing the following command,
mount the database and issues the following comand before openining it,
SQL> alter database recover datafile '< datafile file name.';
SQL> alter database open;
Part 2, if while doing a recovery the archive logs gets corrupted then we are in serious trouble. Rolling forward tranactions need the archive logs to be proper, if they are corrupted we will need some advanced recovery techniques, I forgot what the names of the advanced recovery utilities, but Oracle suggests in such a case the you get in touch with support before using those utilities. But to be more precise and answer your question, I do not think we can recover the database fully with corrupted archive logs, especially if the redo logs have been swtiched. |
| |
Back To Question | |
