Pros and cons of hot and cold backups

Due to not how to contact Oracle so did not answer this question, now after the data summarized below. Later have the opportunity to learn to learn Oracle, do not know how the written test, I hope God did not go to the WC.

Pros and cons of hot and cold backups

The advantages of hot backup are:
1. Can be backed up at the table space or data file level for short backup time.
2. The database is still available for backup.
3. Can reach a second level recovery (revert to a point in time).
4. Almost all database entities can be recovered.
5. Recovery is quick and, in most cases, restored when the database is still working.
The shortage of hot backup is:
1. There is no mistake, otherwise the consequence is serious.
2. If a hot backup is unsuccessful, the resulting results are not available for point-in-time recovery.
3. Because it is difficult to maintain, so be particularly careful, do not allow "failure to end."

The advantages of cold backup are:
1. is a very fast backup method (just copy the file)
2. Easy to archive (simple copy)
3. Easy to recover to a point in time (just copy the file back)
4. Can be combined with the archiving method to restore the "latest state" of the database.
5. Low maintenance, high safety.
Insufficient cold backup is:
1. When used alone, it can only provide a recovery at a point in time.
2. In the process of implementing a backup, the database must be backed up without any other work. In other words, the database must be off state.
3. If disk space is limited, it can only be copied to other external storage devices such as tape, which can be slow.
4. You cannot restore by table or by user.