Copy from http://database.51cto.com/art/200608/30271.htm
1. Cold (Cold Standby)
Cold standby is usually done by regularly backing up the production system database and storing the backup data on media such as tapes, disks, and so on. The backed-up data is normally in a non-active state until a failure occurs that causes the production database system department to be active. The timeliness of cold standby data depends on the most recent database backup. The period of database cold is generally longer.
2, Hot-standby (Warm Standby)
The implementation of hot spares usually requires an alternate database system. It is similar to cold, except that in the event of a production database failure, the data from the standby database can be used for business recovery. Therefore, the recovery time of hot spare is much shorter than that of cold standby. Many of the hot spares are implemented by continuously loading the logs from the production database into the backup database. The timeliness of hot-standby data also depends on the most recent database backup.
3. Full hot standby (hot Standby)
Full hot provisioning is the highest level of database backup. Full hot standby requires a backup database system that is as active as the production database. and the production database is in full sync with the backup database system, and all modifications to the production database are also implemented on the backup database. A fully hot-standby implementation typically requires complex hardware and software technology, so its recovery requires a higher cost relative to cold and hot spares. But at the same time, it also has the shortest recovery time, which is especially important for some important business systems.
Types of database backups