Since I have not been familiar with Oracle, I have not answered this question. I have checked the information and summarized it as follows. I have the opportunity to study oracle in the future. I don't know how the written test is. I hope God didn't go to WC.
Advantages and disadvantages of hot backup and cold backup
Advantages of Hot Backup:
1. Data can be backed up at the tablespace or data file level. The backup time is short.
2. The database is still available during Backup.
3. It can be restored in seconds (to a specific point in time ).
4. Restore almost all database entities.
5. Recovery is fast, and recovery is usually performed when the database is still working.
Hot Backup is insufficient:
1. No error is allowed; otherwise, the consequences are serious.
2. If the Hot Backup fails, the result cannot be used for restoration at a time point.
3. Because it is difficult to maintain, you must be careful not to "end with failure ".
Advantages of cold backup:
1. It is a very fast backup method (just copy files)
2. Easy to archive (simple copy)
3. easy recovery to a certain point in time (you only need to copy the file back)
4. It can be combined with the archiving method to restore the database to the "latest State.
5. Low maintenance and high security.
Insufficient cold backup is:
1. When used separately, only recovery at a certain time point can be provided.
2. During the entire backup process, the database must be backed up instead of other work. That is to say, the database must be closed.
3. If the disk space is limited, it can only be copied to tape and other external storage devices, and the speed will be very slow.
4. data cannot be restored by table or by user.