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?



May 05, 2006 02:04:20 #1
 Noel   Member Since: Visitor    Total Comments: N/A 

RE: while taking hotbackup (begin end backup) what wi...
 

When we r taking  hot backup(begin backup - end backup) ,the datafile heder associated with the datafiles in the corresponding tablespace is frozen.So Oracle will stop updating the datafile header, but will continue to write data into datafiles.In backup oracle will generate more redos , this is beacause  oracle will write out complete changed blocks to the redo log files.

     

 

Back To Question