answersLogoWhite

0


Best Answer

Cold Backup- We can take the Backup while DB(eg. Oracle) is down.
Hot Backup-We can take the Backup while DB(eg. Oracle) is running.

Cold backup is a physicalbackup. During a cold backupthe databaseis closed and not available to users. All files of the databaseare copied (image copy). The datafiles do not change during the copy so the databaseis in sync upon restore.
Used when:Service level allows for some down time for backup
Hot backup is a physical backup. In a hot backup the database remains open and available to users. All files of the database are copied (image copy). There may be changes to the database as the copy is made and so all log files of changes being made during the backupmust be saved too. Upon a restore, the changes in the log files are reapplied to bring the databasein sync. Used when:A full backupof a databaseis needed
Service level allows no down time for the backup

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Explain the difference between a hot backup and a cold backup and the benefits associated with each?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you explain the difference between the vassals and serfs?

Explain the difference between the vassals and the serfs


What is the difference between selling points and benefits?

what is the primary difference between selling points and benefits


What is the difference between water's cohesive and adhesive chemical properties and explain how each property benefits life on earth?

We are not going to do your homework !


Explain the difference between young and mature mountains?

Explain the difference between young and mature mountains?


What is difference between explain and describe?

Describe is what it is and explain is why it is as it is


What is the difference between describe and explain?

Describe is what it is and explain is why it is as it is


Explain the difference between a cash and credit transaction for purchass and sales?

explain the difference between cash and credit transaction


Explain the difference between share of customer and customer equity.?

Explain the difference between share of customer and customer equity


What is the difference between a system and a subsystem?

explain the difference between systems and sub systems


Explain the difference betwwen the two types of feeding?

explain the difference between the two types of feeding?


Explain the difference between the solubility behaviors of glycerol and triglycerides?

Explain the difference between the solubility behaviors of glycerol,fatty acid and triglycerides


Explain the difference between batch processing and real-time processing?

explain the difference between batch processing and real-time processing