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 17 of 42    Print  
What are the different tools available for hot backups. Is it preferable to take it manually all the time or it depends on the size of the database.

  
Total Answers and Comments: 8 Last Update: February 25, 2009     Asked by: rakesh banglore 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: Ritesh Raj singh
 

See A hot backup can be done by either RMAN,User Managed Backups by puting tablespace in backup mode my OEM which does the same as the user managed backup.But the Backup depends upon the size of the database you are using . if the database size in TB the RMAN backup will take more than 10 hours to complete and if the database is critical you can' wait for long to go for so long in this case their are special backup techniques which are given by vendors like TIVOLI and Netbackup they provide BC Vol backup called Business content Volumn Sync which copies a snapshot of the primary data to another place and backsup the database from one SAN to another with in 15 min for 2 TB of database and is the preferable method for big companies.

Regards

Ritesh Raj Singh

Database Administration Team

ICICI Ltd

ICICI Corporate House

Mahalakshmi Mumbai



Above answer was rated as good by the following members:
imran44
March 26, 2006 10:11:48   #1  
bhabani prasad bal        

RE: What are the different tools available for hot bac...
really a nice site
 
Is this answer useful? Yes | No
March 28, 2006 11:20:26   #2  
sivagurublue Member Since: March 2006   Contribution: 2    

RE: What are the different tools available for hot bac...
good question
 
Is this answer useful? Yes | No
April 05, 2006 05:14:41   #3  
Paresh Sarma        

RE: What are the different tools available for hot bac...
RMAN OEM(Oracle Enterprise Manager) depends on size and database mode(Archivelog or No-Archievelog)
 
Is this answer useful? Yes | No
April 19, 2006 06:33:15   #4  
SOURAV GHOSH        

RE: What are the different tools available for hot bac...

one can TOAD tools.This make Oracle almost ACCESS.Actually it is every good tool for development phase.


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
June 27, 2006 14:12:31   #5  
Ritesh Raj singh        

RE: What are the different tools available for hot bac...

See A hot backup can be done by either RMAN User Managed Backups by puting tablespace in backup mode my OEM which does the same as the user managed backup.But the Backup depends upon the size of the database you are using . if the database size in TB the RMAN backup will take more than 10 hours to complete and if the database is critical you can' wait for long to go for so long in this case their are special backup techniques which are given by vendors like TIVOLI and Netbackup they provide BC Vol backup called Business content Volumn Sync which copies a snapshot of the primary data to another place and backsup the database from one SAN to another with in 15 min for 2 TB of database and is the preferable method for big companies.

Regards

Ritesh Raj Singh

Database Administration Team

ICICI Ltd

ICICI Corporate House

Mahalakshmi Mumbai


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
August 24, 2006 00:53:44   #6  
sanjay_pramanaik        

RE: What are the different tools available for hot bac...

There are following tools available for hot backup. which have been used by me.

Oracle Tools

[1] RMAN [2] OEM [3] User Manageed such as making tablespace off line and copy the associated datafiles.

Third Partry Tools

[1] Net Vault

[2] Tivoly

Sanjay


 
Is this answer useful? Yes | No
March 30, 2007 18:15:36   #7  
Chiranjeevi Manne        

RE: What are the different tools available for hot bac...
1. Using OS level filesystem backup tools
2. RMAN utility
3. Using traditional hot backup methos like keeping the tablespace in backup mode and the using OS level copy command to copy the datafiles to the backup location

 
Is this answer useful? Yes | No
February 24, 2009 06:03:45   #8  
bhendega Member Since: January 2009   Contribution: 3    

RE: What are the different tools available for hot backups. Is it preferable to take it manually all the time or it depends on the size of the database.

In oracle there are different tools for hot backup
RMAN

OEM

As per my view

it's depends on size of database as well as role of database.

RMAN is best for hot backup this tool we have lot of option for backup.


 
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