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  >  Basics

 Print  |  
Question:  What is the difference between cold backup and hot backup



February 02, 2009 04:36:45 #4
 krishnaprasad.sola   Member Since: February 2009    Total Comments: 10 

RE: What is the difference between cold backup and hot backup
 

Cold Backup is possible only when the database is down means it is not available to users to access. Disadvantage is we effort downtime. Here we need to take backup of datafiles, control files, redo files. Here we get consistent backup image.

Hot backup is possible in database open mode means database is available to users while taking backup. Here we need to take backup of datafiles, controls. Here there is no guarantee that backup is consistent.Disadvantage is Excessive redo generation.

     

 

Back To Question