imran44

 Profile Answers by imran44 

• Dec 30th, 2008

 

Hot backup when the database is online, cold backup is taken during shut down period

mb.appsdba

 Profile Answers by mb.appsdba 

• Aug 27th, 2010

 

Backup taken when database is shutdown is called as cold backup and the backup taken when the database is up and running is called as hot backup.

Deshpande Umesh

 Profile Answers by Deshpande Umesh 

• Nov 16th, 2010

 

Cold backup is a backup of database when datafiles are not opened. Hot backup is a backup when datafiles are opend and operational.
Suppose your database is in mount stage ( not shutdown ) and you take a backup then it is also a cold backup since datafiles are not opened.