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
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.
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
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.