Difference between hot backup and cold backup?
Posted by silpa on Sep 17 2007
hot backup is taking backup of db while its still up and running and must be in archive log mode
cold backup is taking backup of database when its shutdown and not required to be in archive log mode.
advantage
hot backup - db is available for use and can recover at any point of time
cold backup - easier to administer the backup and recovery process
doesn’t require archive log mode so performance is increased
Leave a Comment