建议目的端执行(源端也可以执行)
rman target sys/oracle@tnsora11g_source auxiliary sys/oracle@tnsora11g_target
run{ allocate channel prmy1 type disk; allocate channel prmy2 type disk; allocate channel prmy3 type disk; allocate auxiliary channel stby1 type disk; allocate auxiliary channel stby2 type disk; allocate auxiliary channel stby3 type disk; duplicate target database to ora11gcp from active database nofilenamecheck password file spfile parameter_value_convert='ora11g','ora11gcp' set db_unique_name='ora11gcp' set instance_name='ora11gcp' set cluster_database='false' set control_files='/u01/app/oracle/oradata/ora11gcp/control01.ctl','/u01/app/oracle/oradata/ora11gcp/control02.ctl' set log_file_name_convert='/u01/app/oracle/oradata/ora11g','/u01/app/oracle/oradata/ora11gcp' set db_file_name_convert='/u01/app/oracle/oradata/ora11g','/u01/app/oracle/oradata/ora11gcp' set log_archive_dest_1='LOCATION=/u01/archivelog' set audit_file_dest='/u01/app/oracle/admin/ora11gcp/adump' set diagnostic_dest='/u01/app/oracle' set sga_target='3G' set sga_max_size='3G' set undo_tablespace='UNDOTBS1' reset remote_listener reset local_listener reset db_create_file_dest logfile group 1 ('/u01/app/oracle/oradata/ora11gcp/redo01_1.f','/u01/app/oracle/oradata/ora11gcp/redo01_2.f') size 50m, group 2 ('/u01/app/oracle/oradata/ora11gcp/redo02_1.f','/u01/app/oracle/oradata/ora11gcp/redo02_2.f') size 50m, group 3 ('/u01/app/oracle/oradata/ora11gcp/redo03_1.f','/u01/app/oracle/oradata/ora11gcp/redo03_2.f') size 50m, group 4 ('/u01/app/oracle/oradata/ora11gcp/redo04_1.f','/u01/app/oracle/oradata/ora11gcp/redo04_2.f') size 50m ; release channel prmy1; release channel prmy2; release channel prmy3; release channel stby1; release channel stby2; release channel stby3; }
标签:set,ora11gcp,克隆,数据库,duplicate,oradata,oracle,app,u01 From: https://www.cnblogs.com/hxlasky/p/17916706.html