Saturday, February 15, 2014

Cold backup and hot backup in Oracle

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

How to create user in MY SQL

Create  a new MySQL user Account mysql > CREATE USER ' newuser '@'localhost' IDENTIFIED BY ' password '...