What is a cold backup?

This article will explain in detail what cold backup is, and the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

What is a cold backup?

Cold backup, also known as offline backup, refers to the full backup of the database when the database is closed and the database cannot be updated, and the data can be specified to be restored, which is easy to operate. and cold-backed databases can work in non-archive mode.

Advantages of cold backup

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

2. Easy to file (simply copy)

3. Easy to 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.

Cold backup disadvantage

1. When used alone, it can only provide recovery to "at a certain point in time".

2. In the whole process of implementing backup, the database must be backed up and no other work can be done. That is, during a cold backup, the database must be closed.

3. If the disk space is limited, it can only be copied to other external storage devices such as magnetic tape, and the speed will be very slow.

4. Cannot restore by table or by user.

If possible (mainly depending on efficiency), back up the information to disk, then start the database (so that the user can work) and copy the backed up information to tape (while copying, the database can also work).

About what cold backup is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.