最近准备将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/END BACKUP语句 | Supported. Must use 支持。需要使用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 | 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. 支持。 |