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:  what is the difference between media recovery & crash recovery..?



September 09, 2006 09:28:48 #8
 shabirwani   Member Since: September 2006    Total Comments: 2 

RE: what is the difference between media recovery & cr...
 

oracle never accepts the inconsistency of the database. so when oracle goes down due to power outage or aborted manually, next time once the database base is opened it goes mainly to the three states nomount,mount,and open when oracle try to open the database it makes check of SCN in the controlfile and each database datafile header if the check is not correct it will try to perform crash recovery and apply the online redo logs to bring the database in consistent state. By any means if it could not apply then it will try to locate the archive logs to apply and asks for media recovery.  

     

 

Back To Question