bhabani prasad bal

• Mar 26th, 2006

 

really a nice site

sivagurublue

 Profile Answers by sivagurublue 

• Mar 28th, 2006

 

good question

Paresh Sarma

• Apr 5th, 2006

 

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

SOURAV GHOSH

• Apr 19th, 2006

 

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

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.

Regards

Ritesh Raj Singh

Database Administration Team

ICICI Ltd

ICICI Corporate House

Mahalakshmi Mumbai

sanjay_pramanaik

• 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

Sanjay

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

bhendega

 Profile Answers by bhendega 

• Feb 24th, 2009

 

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.