GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Backup and Recovery
Go To First  |  Previous Question  |  Next Question 
 Backup and Recovery  |  Question 32 of 42    Print  
Types of Backup
What are different types of backup? (Hot, Cold, logical, Physical) Explain in detail.


  
Total Answers and Comments: 3 Last Update: September 12, 2008     Asked by: Pragati.rch 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 29, 2008 10:32:51   #1  
ayubfkhan Member Since: February 2008   Contribution: 1    

RE: Types of Backup
Hot backups are when database is up and running you take backup(DB has to be in archivelog mode in order to do that.) Cold backups are shutdown the database and copy datafiles control files and save them some place safer(on a different server) Good dba should do that atleast once a month. When you rman backups benefit is that it only backsup blocks that have been used empty data does not get backed up. This is very efficient as far as space issues go.
 
Is this answer useful? Yes | No
May 01, 2008 10:26:47   #2  
suchoudh Member Since: May 2008   Contribution: 2    

RE: Types of Backup
logical backups are export dumps
 
Is this answer useful? Yes | No
September 12, 2008 11:03:15   #3  
joshanil Member Since: September 2008   Contribution: 1    

RE: Types of Backup
1. Hot inconsistance and online backup are same
2. Cold close consistance and offline backup are same

For 1. db must be archive mode inconsistance mean the SCN are not same
For 2. db may be archive mode consistance mean SCN are same (controlfile datafile)

Logical backup through import/export utilities
Physical backup simply copy all file using OS command

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape