|
Difference between a hot backup and a cold backup in oracle.A cold backup is done when there is no user activity going on with the system. Also called as offline backup, is taken when the database is not running and no users are logged in. all files of the database are copied and no changes during the copy are made.
A hot backup is taken when the database needs to run all the time. It is an online backup. All files of the database are copied and there may be changes to the database during the copy.
The benefit of taking a hot backup is that the database is available for use while the backup is occurring and one can recover the database to any point in time. The benefit of taking a cold backup is that it is typically easier to administer the backup and recovery process. For cold backups the database does not require being in archive log mode and thus there will be a slight performance gain as the database is not cutting archive logs to disk.
|
