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

 Print  |  
Question:  While taking hot backup (begin end backup) what will happens back end?



September 09, 2007 10:32:15 #6
 priyanka   Member Since: Visitor    Total Comments: N/A 

RE: While taking hot backup (begin end backup) what w...
 
When the database is taken in backup mode the checkpoint takes place and the datafile header gets frozen
As the checkpoint takes place the database writer writes all the blocks from database buffer cache to datafiles.The same blocks are also written from the redo log buffer in the redo log files. So the archive log generation becomes high
OS blocks differ from oracle blocks so there can be fractured block that needs recovery. This is the reason why all the blocks are written in the redolog files when the database is in backup mode
     

 

Back To Question