Oracle Backup: The difference between Rman and Exp/imp

Rman is a physical-structured backup based on data block backup, supporting the recovery operation with online redolog and archive Redolog, and is Oracle's recommended backup recovery tool.

The data imp/exp is a logical structure based import export tool that is based on the Import export tool for data objects (such as tables, stored procedures, and so on) and does not support the use of online redolog and archive Redolog, if used as backup and restore only to the point at which it was exported , Oracle's Recommended data mobility tool, that can be exported from one library and then imported to another library.

The general database backup strategy is recommended to use Rman to do backups every day, using data exp to do export backups every few days, so that if the physical structure of data files such as failure can use Rman+redolog recovery, if only restore a table can be directly imported with data imp, improve efficiency.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/