oracle11gRMAN:ActiveDatabaseDuplicationforstandbydatabase创建dg命令解读(三)

2015-01-22 21:10:12 · 作者: · 浏览: 15
MP=0 channel prmy3: datafile copy complete, elapsed time: 00:00:24 output file name=/u02/app/oracle/oradata/boston/users01.dbf tag=TAG20080519T173421 RECID=0 STAMP=0 channel prmy4: datafile copy complete, elapsed time: 00:00:16 output file name=/u02/app/oracle/oradata/boston/system01.dbf tag=TAG20080519T173421 RECID=0 STAMP=0 channel prmy1: datafile copy complete, elapsed time: 00:02:32 output file name=/u02/app/oracle/oradata/boston/sysaux01.dbf tag=TAG20080519T173421 RECID=0 STAMP=0 channel prmy2: datafile copy complete, elapsed time: 00:02:32 Finished backup at 19-MAY-08 sql statement: alter system archive log current contents of Memory Script: { switch clone datafile all; ---------修改standby 控制文件,更新standby 控制文件中的新数据文件路径 } executing Memory Script datafile 1 switched to datafile copy input datafile copy RECID=2 STAMP=655148231 file name=/u02/app/oracle/oradata/boston/system01.dbf datafile 2 switched to datafile copy input datafile copy RECID=3 STAMP=655148231 file name=/u02/app/oracle/oradata/boston/sysaux01.dbf datafile 3 switched to datafile copy input datafile copy RECID=4 STAMP=655148231 file name=/u02/app/oracle/oradata/boston/undotbs01.dbf datafile 4 switched to datafile copy input datafile copy RECID=5 STAMP=655148231 file name=/u02/app/oracle/oradata/boston/users01.dbf Finished Duplicate Db at 19-MAY-08 released channel: prmy1 released channel: prmy2 released channel: prmy3 released channel: prmy4
到这里备库环境已经全部初始化完毕,免去了我们以前需要,手动在备库配置pfile参数文件,手动拷贝密码文件到备库,创建standby控制并拷贝到备库,拷贝数据文件备份到备库 等等步骤但是看到这里,还是有个疑惑的oracle 是怎么直接拷贝那些密码文件,参数文件,控制文件,数据文件到备库的?这里猜测应该是调用了rman 某些接口,说的直白点就是和nbu 那些第三方数据备份软件用的那一招,现在oracle自己觉得这些个接口也可以这么用,于是乎在11g(11.1.0.6 开始) 中推出了 active—database duplicate 关于这个feature oracle官方是这么讲的:
Active database duplication copies the live target database over the network to the auxiliary destination and then creates the duplicate database.
The duplication work is performed by an auxiliary channel.This channel corresponds to a server session on the auxiliary instance on the auxiliary host.


以下为 Basic Steps to ACTIVE database duplication 过程中rman干的事情 :
As part of the duplicating operation, RMAN automates the following steps:
1. Creates a control file for the duplicate database
2. Restarts the auxiliary instance and mounts the duplicate control file
3. Creates the duplicate datafiles and recovers them with incremental backups and archived redo logs.
4. Opens the duplicate database with the RESETLOGS option