Basics - What is the difference between cold backup and hot backup

GeekInterview.com > Interview Questions > Oracle > Basics

Go To First | Previous Question | Next Question

Basics | Question 38 of 49

What is the difference between cold backup and hot backup

Total Answers and Comments: 4

Last Update: February 09, 2009 Asked by: Sridhar

Sponsored Links

Best Rated Answer

—

Submitted by: ttparavindh

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 physical backup. During a cold backup the database is closed and not available to users. All files of the database are copied (image copy). The datafiles do not change during the copy so the database is 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 backup must be saved too. Upon a restore, the changes in the log files are reapplied to bring the database in sync. Used when:A full backup of a database is needed
Service level allows no down time for the backup

Above answer was rated as good by the following members:
manojpal, saginandkishore, dishashah, praveenkarthik

June 19, 2007 07:47:21

ttparavindh

Member Since: June 2007 Contribution: 6

RE: What is the difference between cold backup and hot...

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 physical backup. During a cold backup the database is closed and not available to users. All files of the database are copied (image copy). The datafiles do not change during the copy so the database is 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 backup must be saved too. Upon a restore the changes in the log files are reapplied to bring the database in sync. Used when:A full backup of a database is needed
Service level allows no down time for the backup

Is this answer useful? Yes | No

4 0

Overall Rating: +4

September 12, 2008 01:57:54

lanka_satya

Member Since: January 2008 Contribution: 16

RE: What is the difference between cold backup and hot backup

both are inverse...if we take the case with cold back we copy the all the physical files of the database i.e control files data files redo logs.this w3e do in non peak hours

hot back up is somthing which is used to tabke backup of logical database that is our tablespaces....

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 07, 2009 20:28:24

srk.srikanth

Member Since: February 2009 Contribution: 1

RE: What is the difference between cold backup and hot backup

Cold Backup: Need to back up Database Files Control Files Online Redo Log files.
Hot Backup: Need to back up Database Files ControlFiles Offline Redo Log files (archive files).

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 09, 2009 04:36:45

krishnaprasad.sola

Member Since: February 2009 Contribution: 19

RE: What is the difference between cold backup and hot backup

Cold Backup is possible only when the database is down means it is not available to users to access. Disadvantage is we effort downtime. Here we need to take backup of datafiles control files redo files. Here we get consistent backup image.

Hot backup is possible in database open mode means database is available to users while taking backup. Here we need to take backup of datafiles controls. Here there is no guarantee that backup is consistent.Disadvantage is Excessive redo generation.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank