<<Previous Next>>
Oracle - Difference between a hot backup and a
cold backup - Feb 18, 2010 at 11:00 PM by Rajmeet
Ghai
Difference between a hot backup and a cold backup
A cold backup is taken when database is not running. This means
no users should be logged and no activity in progress. Because of
this there are no changes in the data files while backup is being
taken. This makes it easier to take a back up.
Hot backup is entirely the opposite and is usually taken when the
database has to run all the time due to critical requirements.
Because of this there may be changes in the data files while backup
is being
taken.
Oracle - Difference between
a hot backup and a cold backup - Feb 07, 2010 at 14:20 PM
by Shuchi Gauri
Difference between a hot backup and a cold
backup
Cold backup: It is taken when
the database is closed and not available to users. All files of the
database are copied (image copy). The datafiles cannot be changed
during the backup as they are locked, so the database remains in
sync upon restore.
Hot backup: While taking the backup, if the database remains
open and available to users then this kind of back up is referred to
as hot backup. Image copy is made for all the files. As, the
database is in use the entire time, so there might be changes made
when backup is taking place. These changes are available in log
files so the database can be kept in
sync
Oracle -
Difference between a hot backup and a cold backup - April
10, 2009 at 11:00 AM
Difference between a hot backup and a cold
backup
Cold Backup
In this type of backup, after the database is shut down, DBA
exits the SVRMGR utility and copies the log files, data files and
control files onto a backup media. Once the backup has been
completed the DBA can restart the database.
Hot backup
A few systems that need to support
continuous operation, it is difficult to bring down the database
without interrupting the service provided to the users. In such
cases, hot backup approach should be used.
Also read
Describe the Oracle backup, i.e. archive log mode, cold and hot
backups, incremental backups..............
What is configure command and recovery catalog?, What are different
types of backup? (Hot, Cold, logical, Physical)?, Whats the
Concept of Flashback Query in Oracle (10g in particular) and how
is it beneficial?................
| 
