Oracle - 11GR2 - RAC - to - RAC - DATAGUARD - 配置方案(3)

1.5.8 复制库

使用11G的新特性，在线方式的RMAN DUPLICATE技术。

--在主库节点上执行 --创建复制脚本 $ more duplicate_act_standby.rcv duplicate target database for standby from active database spfile set db_unique_name='orclstd' set control_files='+DATA/orclstd/controlfile/current.256.869873351' set db_file_name_convert='+DATA','+DATA' set log_file_name_convert='+DATA','+DATA' set log_archive_config='DG_CONFIG=(orcl,orclstd)' set log_archive_dest_1='LOCATION=+DATA VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orclstd' set log_archive_dest_2='SERVICE=orcl ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl' set fal_client='orclstd' set fal_server='orcl' set remote_listener='clusterstd-scan:1521' set standby_file_management='AUTO' nofilenamecheck; --执行复制操作 $rman --复制完成后，备库实例自动启动到mount状态 select instance_name,status from v$instance; --检查数据文件和redo日志等相关信息 set line 1000 col name format a50 col member format a50 select name from v$datafile_header; select * from v$log; target sys/oracle@orcl1 auxiliary sys/oracle@orclstd1 cmdfile=duplicate_act_standby.rcv log=rman.log select * from v$logfile; show parameter control; show parameter spfile; show parameter db_name; show parameter db_unique_name;