Difference and advantage of using a Hot Backup and a Cold Backup

Asked By Marsha_Moyer 0 points N/A Posted on - 11/08/2011

I would like to know the difference and advantage of using a Hot Backup and a Cold Backup. I also need help to restore the database from the backup without any control files. Can anyone help me on this?

• Status: Open
• Question Views: 866
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Mahesh Babu 20 points N/A #107816

Difference and advantage of using a Hot Backup and a Cold Backup

Hello Marsha,

Hot backup is a kind of backup that is dynamic or active. It is done when database is running and data is being updated, added, or read by its users. What is does not do is handle running transactions at the time of backup.

The hot backup is limited to the database management system (DBMS) facility only, and it is advisable that they should be done during low working hours. Hot backups do not require downtime; hence they are taken in environments where database is intended to be online 24-hours a days and 7-days a week.

Cold backup on the other hand is taken when database is offline. It is not accessible for updating and it cannot be used at that time.

It can be done by the database management system as well as the OS. They are mostly taken during weekends or during the end or a working day, a time when the database is offline

With cold backup, the database does not have to be running 24 hours a day; it could be taken in intervals.

__

Regards
Mahesh Babu

About Mahesh Babu

Questions
1

Answers
473

Best Answers
87

• Vote Up 0 Vote Down

• Posted on - 11/08/2011
• Question Category: Misc Databases