alter system set instance_name='prd' scope=spfile;
alter system set db_unique_name='prd' scope=spfile;
alter system set local_listener='prd' scope=spfile;
alter system set log_archive_config='DG_CONFIG=(prd,pra)';
alter system set log_archive_dest_1='LOCATION=/u01/arch valid_for=(all_logfiles,all_roles) db_unique_name=prd' scope=spfile;
alter system set log_archive_dest_2='SERVICE=pra lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=pra' scope=spfile;
alter system set log_archive_format='arch_%r_%t_%s.arc' scope=spfile;
alter system set fal_client='prd' scope=spfile;
alter system set fal_server='pra' scope=spfile;
alter system set standby_file_management=AUTO;
alter database add standby logfile group 4 '/u01/app/oracle/oradata/prd/standby04.log' size 50M;
alter database add standby logfile group 5 '/u01/app/oracle/oradata/prd/standby05.log' size 50M;
alter database add standby logfile group 6 '/u01/app/oracle/oradata/prd/standby06.log' size 50M;
alter database add standby logfile group 7 '/u01/app/oracle/oradata/prd/standby07.log' size 50M;
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby nofilenamecheck from active database
dorecover
spfile
parameter_value_convert 'prd','pra'
set instance_name='pra'
set db_unique_name='pra'
set local_listener='pra'
set db_file_name_convert='/u01/app/oracle/oradata/prd/','/u01/app/oracle/oradata/pra/'
set log_file_name_convert='/u01/app/oracle/oradata/prd/','/u01/app/oracle/oradata/pra/'
set control_files='/u01/app/oracle/oradata/pra/control01.ctl','/u01/app/oracle/oradata/pra/control02.ctl','/u01/app/oracle/oradata/pra/control03.ctl'
set log_archive_dest_1='LOCATION=/u01/arch valid_for=(all_logfiles,all_roles) db_unique_name=pra'
set log_archive_dest_2='SERVICE=prd lgwr async valid_for=(online_logfile,primary_role) db_unique_name=prd'
set log_archive_max_processes='5'
set standby_file_management='AUTO'
set fal_client='pra'
set fal_server='prd';
release channel c1;
release channel c2;
release channel stby;
}
转载请注明原文地址: https://ju.6miu.com/read-1300058.html
