11GR2备份方法区别比较

最近准备将11GR2 Oracle Database Backup and Recovery User's Guide文档中的东西再看看，好好研究一下备份恢复，再练习一下里面的案例。

今天先下记录一下各种备份方法的区别，后续将每天记录一下学习情况

官方文档如下：

 

Feature	Recovery Manager（RMAN）	User-Managed（用户手动备份）	Data Pump Export（数据泵导出）
Closed database backups 数据库关闭	Supported. Requires instance to be mounted. 支持。需要实例处于mount状态。	Supported. 支持。	Not supported. 不支持。
Open database backups 数据库开启	Supported. No need to use BEGIN/ENDBACKUP statements. 支持。不需要使用BEGIN/END BACKUP语句	Supported. Must use BEGIN/END BACKUPstatements. 支持。需要使用BEGIN/END BACKUP语句	Requires rollback or undo segments to generate consistent backups. 需要回滚段或undo段来生成一致性备份
Incremental backups 增量备份	Supported. 支持。	Not supported. 不支持。	Not supported. 不支持。
Corrupt block detection 坏块检测	Supported. Identifies corrupt blocks and logs in V$DATABASE_BLOCK_CORRUPTION. 支持。识别坏块并记录在V$DATABASE_BLOCK_CORRUPTION	Not supported. 不支持。	Supported. Identifies corrupt blocks in the export log. 支持。识别坏块记录在export日志中
Automatic specification of files to include in a backup 备份中自动规范文件	Supported. Establishes the name and locations of all files to be backed up (whole database, tablespaces, data files, control files, and so on). 支持。创建所有文件备份的name和位置	Not supported. Files to be backed up must be located and copied manually. 不支持。备份文件需要手动拷贝到某个位置	Not applicable. 不适用。
Backup repository 备份知识库	Supported. Backups are recorded in the control file, which is the main repository of RMAN metadata. Additionally, you can store this metadata in a recovery catalog, which is a schema in a different database. 支持。备份记录在控制文件中，控制文件时RMAN元数据的主要知识库。除此以外，可以储存在catalog库中	Not supported. DBA must keep own records of backups. 不支持。DBA需要保留备份记录。	Not supported. 不支持
Backups to a media manager	Supported. Interfaces with a media manager. RMAN also supports proxy copy, a feature that allows a media manager to manage completely the transfer of data between disk and backup media.	Supported. Backup to tape is manual or controlled by a media manager.	Not supported.
Backup of initialization parameter file 备份初始化参数文件	Supported. 支持。	Supported. 支持。	Not supported. 不支持。
Backup of password and networking files 备份密码和networking文件	Not supported. 不支持。	Supported. 支持。	Not supported. 不支持。
Platform-independent language for backups 独立语言平台for backups	Supported. 支持。	Not supported. 不支持。	Supported. 支持。