Page 1 of 1

Backup (Hot & Cold)

Posted: Sun May 31, 2009 5:19 am
by Kashif
Hello Memebrs

Can any one tell me the Difference between HOT Backup and Cold backup

Thanks and Regards

Kashif

Posted: Sun May 31, 2009 11:03 pm
by amirtai
Hi there

It could be described as, in the HOT backup you don't need to shutdown the database (mostly preferred for PROD database). The RMAN and some other third party backup solutions using RMAN scripts in the background are used for that purpose.

In the cold backup you just need to shutdown the database and move your data files and other important files to backup target storage device.

Regards
Amir