400-090-9964


博客 | 论坛

教学文章

秒速飞艇平台 Study之--秒速飞艇平台 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 秒速飞艇平台 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.


秒速飞艇平台 11gRMAN duplicate 可以通过Active database duplicateBackup-based duplicate两种方法实现。本案例使用的是Active database duplicate,对于Active database duplicate来说,在克隆数据库时不用对Source备份,这对于大数据特别是T级别的数据库来说优点非常明显,复制前不需要进行备份,减少了备份和传送备份的手机版,同时节省备份空间。
克隆数据库一般是在不同的主机上来完成,本案例是测试环境,所以在一台主机上完成。


版权所有@北京神脑资讯技术有限公司(CUUG,中国UNIX用户协会) Copyright 秒速飞艇平台   2017 ALL Rights Reserved 京ICP备46713993号 京公网110108006275号

CUUG旗下网站:www.idodressau.com.cn www.idodressau.com 秒速飞艇平台.cuug.com bbs.cuug.com bd.cuug.com

电话:0330-78063645 0330-78063645 邮政编码:100089

海淀校区:北京市海淀区紫竹院路88号紫竹花园4号楼D座703(CUUG)

昌平校区:北京昌平区沙河镇科技经营管理学院教学楼主楼9层

西安校区:陕西省西安市长安北路中贸广场15号楼2单元2509