您的位置:首页 > 博客中心 > 数据库 >

使用 rman duplicate from active database 搭建dataguard 手记

时间:2022-03-14 11:56



run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate channel prmy5 type disk;
allocate channel prmy6 type disk;
allocate channel prmy7 type disk;
allocate channel prmy8 type disk;
allocate channel prmy9 type disk;
allocate channel prmy10 type disk;

allocate auxiliary channel stby1 type disk;
allocate auxiliary channel stby2 type disk;
allocate auxiliary channel stby3 type disk;
allocate auxiliary channel stby4 type disk;
allocate auxiliary channel stby5 type disk;
allocate auxiliary channel stby6 type disk;
allocate auxiliary channel stby7 type disk;
allocate auxiliary channel stby8 type disk;
allocate auxiliary channel stby9 type disk;
allocate auxiliary channel stby10 type disk;
duplicate target database for standby from active database dorecover;
}


dorecover:会将备份期间产生的归档日志应用到standby database,但是不会启动日志应用(not  use manual or managed recovery mode.)
Specifies that RMAN should recover the standby database after creating it.

If DORECOVER is specified, then RMAN also recovers the database. The standby database is left mounted after duplication is complete.

RMAN leaves the standby database mounted after media recovery is complete, but does not place the standby database in manual or managed recovery mode. After RMAN creates the standby database, you must resolve any gap sequence before placing it in manual or managed recovery mode, or opening it in read-only mode.


注意点:
在磁盘io不是瓶颈时,一定要考虑下网络带宽;
根据网络带宽,rman 估算综合评估备份时间



版权声明:本文为博主原创文章,未经博主允许不得转载。

本类排行

今日推荐

热门手游