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 07:10:55 #2
 noyal   Member Since: November 2005    Total Comments: 1 

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

The two things will happen when the tablespace in backup mode

1.) The datafile header associated with the tablespace in the backup up mode will be in frozen state.So it stops updating the datafile header, but it continually writes into the datafile.

2.) More redos are generated.This is because oracle will write all the changed blocks into the redo log.Normally only the changes are logged into the redo logs.

regards,

Noyal

     

 

Back To Question