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.

Showing Answers 1 - 8 of 8 Answers

bhabani prasad bal

  • Mar 26th, 2006

really a nice site

  Was this answer useful?  Yes

Paresh Sarma

  • Apr 5th, 2006

RMAN,OEM(Oracle Enterprise Manager),depends on size and database mode(Archivelog or No-Archievelog)

  Was this answer useful?  Yes


  • Apr 19th, 2006

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

  Was this answer useful?  Yes

Ritesh Raj singh

  • Jun 27th, 2006

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.


Ritesh Raj Singh

Database Administration Team


ICICI Corporate House

Mahalakshmi Mumbai


  • Aug 24th, 2006

   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


  Was this answer useful?  Yes

Chiranjeevi Manne

  • Mar 30th, 2007

 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

  Was this answer useful?  Yes


  • Feb 24th, 2009

In oracle there are different tools for hot backup


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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions