GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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, 2008 07:58:23 #3
 mojidra   Member Since: September 2008    Total Comments: 5 
RE: Corrupted Archieve Logs
 

Your database in archive log mode one of your archive file is missing there is no way to performed complete recovery you can able to do incomplete recovery, recover database till cancelled or there is another way if you have a export copy of that datafile latest than that archive log file missed then import that datafile data loss is lesser as compared to incomplete recovery.
     

 

Back To Question