Oracle Study之--Oracle 11gR2通过RMAN克隆数据库

时间：2016-04-19 来源：

Purpose of Database Duplication

A duplicate database is useful for a variety of purposes, most of which involve testing. You can perform the following tasks in a duplicate database:

Test backup and recovery procedures
Test an upgrade to a new release of Oracle Database
Test the effect of applications on database performance
Create a standby database
Generate reports

Techniques for Duplicating a Database

RMAN supports two basic types of duplication: active database duplication and backup-based duplication. RMAN can perform backup-based duplication with or without either of the following connections:

Target
Recovery catalog

A connection to both is required for active database duplication.

Figure 24-1 shows the decision tree for the two duplication techniques.

Active Database Duplication

In active database duplication, RMAN connects as TARGET to the source database instance and as AUXILIARY to the auxiliary instance. RMAN copies the live source database over the network to the auxiliary instance, thereby creating the duplicate database. No backups of the source database are required. Figure 24-2 illustrates active database duplication.

Oracle 11g的RMAN duplicate 可以通过Active database duplicate和Backup-based duplicate两种方法实现。本案例使用的是Active database duplicate，对于Active database duplicate来说，在克隆数据库时不用对Source备份，这对于大数据特别是T级别的数据库来说优点非常明显，复制前不需要进行备份，减少了备份和传送备份的时间，同时节省备份空间。

克隆数据库一般是在不同的主机上来完成，本案例是测试环境，所以在一台主机上完成。