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:  
Can Full Backup be performed when the database is open ?

Answer:
No.


October 10, 2007 22:13:03 #9
 satyam_2007   Member Since: October 2007    Total Comments: 5 
Can Full Backup be performed when the d...
 
Online backup can be whole and partial, be full and incremental, and be carried out with RMAN or with the operating system commands. But they can only be done if the database is in archivelog mode.

A datafile that is backed up online will not be synchronized with any particlular SCN, nor it is synchronized with the other datafiles or the control files. It is backed up while it is in use: being read from by server processes, and written by DBWn.
     

 

Back To Question