What is the difference between cold backup and hot backup

Today, I will talk to you about the difference between cold backup and hot backup. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can gain something according to this article.

Cold backup

Cold backup occurs when the database has been normally closed, when the normal shutdown will provide us with a complete database. A term for copying critical files to another location during a cold backup. For backing up Oracle information, cold backup is the fastest and safest way. The advantages of cold backup are:

1. It is a very fast backup method (just copy files)

2. Easy filing (simple copy)

3. Easily restore to a certain point in time (just copy the file back)

4. It can be combined with the archiving method to restore the "best state" of the database.

5. Low maintenance and high safety.

Hot backup

Hot backup is a method that uses archivelog mode to back up the database when the database is running. So, if you have a cold backup from last night and a hot backup file from today, you can use this data to recover more information when something goes wrong. Hot backup requires the database to operate in Archivelog mode and requires a lot of file space. Once the database is running in the archivelog state, you can make a backup. The hot backup command file consists of three parts:

1. Backup of data files, one table space, one table space.

(1) set the tablespace to backup status

(2) backup the data files of the tablespace

(3) the reply table space is normal.

2. Back up archived log files

(1) temporarily stop the archiving process

(2) those files in the archive rede log target directory under log

(3) restart the archive process

(4) back up archived redo log files

3. The advantages of using alter database bachup controlfile command to backup control files are as follows:

1. It can be backed up in table space or database file level, and the backup time is short.

2. The database can still be used during backup.

3. It can recover in seconds (recover to a certain point in time).

4. Almost all database entities can be restored

5. Recovery is fast, and in most cases love recovering when the database is still working.

After reading the above, do you have any further understanding of the difference between cold backup and hot backup? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.