Cold
Backup,
A cold
backup is taking a backup of the database while it is shut down and does not
require being in archive log mode. The benefit of taking a cold backup is
that it is typically easier to administer the backup and recovery process.It
is Copying the three sets of files (database files, redo logs, and
control file) when the instance is shut down.You must shut down the instance to guarantee a consistent
copy.
If a cold
backup is performed, the only option available in the event of data file loss
is restoring all the files from the latest backup. All work performed on
the database since the last backup is lost.
Hot
Backup:
A hot
backup is basically taking a backup of the database while it is still up and
running and it must be in archive log mode.We use to setup host back where
cannot shut down the database while making a backup copy of the files.Or the
cold backup is not an available option.
If a data
loss failure does occur, the lost database files can be restored using the hot
backup and the online and offline redo logs created since the backup was
done. The database is restored to the most consistent state without any loss
of committed transactions.The benefit of taking a hot backup is that
the database is still available for use while the backup is occurring and
you
can recover the database to any point in time.
No comments:
Post a Comment