oracle数据库dataguard， 备库在线热克隆主库

备库：创建duplicate.rcv文件，内容如下：

duplicate target database

for standby

from active database

nofilenamecheck

dorecover

spfile

set db_unique_name='c02orcl'

set remote_listener='scan3.lab.example.com:1521'

set audit_file_dest='/u01/app/oracle/admin/c02orcl/adump'

set log_archive_dest_2='service=c01orcl valid_for=(primary_role,online_logfiles) db_unique_name=c01orcl'

set control_files='+DATA','+FRA'

set db_file_name_convert='C01ORCL','C02ORCL'   #查select name from v$datafile确定大小写

set log_file_name_convert='C01ORCL','C02ORCL'  # 查 select member from v$logfile;

set instance_number='1'

set dg_broker_config_file1='+data/c02orcl/dr1c02orcl.dat'

set dg_broker_config_file2='+fra/c02orcl/dr2c02orcl.dat'

set dispatchers='(PROTOCOL=TCP) (SERVICE=c02orclXDB)'

;

oracle ：

执行：rman target sys/oracle_4U@c01orcl1 auxiliary sys/oracle_4U@c02orcl1 cmdfile=duplicate.rcv