使用 rman duplicate from active database 搭建dataguard 手记--系列二
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 估算综合评估备份时间
相关文章
- How I can obtain the collation of a specific table in a database?
- SQL Server 2012 copy database without data
- What is the difference between Shrink Database and File?
- Database ORM
- 第三十一章 SQL命令 DROP DATABASE
- DROP DATABASE - 删除一个数据库
- 基于ABP的应用执行Update-Database出现异常的解决办法
- YII2数据库操作出现类似Database Exception – yiidbException SQLSTATE[HY000] [2002] No such file or director
- 数据库入门必读书籍推荐《Beginning Database Design》和《《Beginning SQL Queries》
- Graph database_neo4j 底层存储结构分析(8)
- mysql中数据库database、实例instance、会话session的关系