What is difference between a hot backup and a cold backup?
Posted Answers
A hot backup is essentially taking the backup of the database despite the fact that it is still up and in operation and it should be in archive log mode. And cold backup means, we backup when the database is shut downed. If we talk about the benefit difference between these both type of backups then the hot backup means the database still available for use during we take backup and we can recover backup at any point, whereas taking the cold backup will ease the administration of the backup and recovery process. In adding together, as cold backups doesn’t require to be in archive log mode and this will gain slight performance as compare to hot backup.
Answer by: Anonymous
