一键 rman duplicate 搭建adg备库

最新推荐文章于 2024-07-23 14:29:59 发布

whn1977

最新推荐文章于 2024-07-23 14:29:59 发布

阅读量421

点赞数

文章标签： big data oracle 数据库

本文链接：https://blog.csdn.net/whn1977/article/details/120540956

版权

这一键有点长：

rman target sys/oracle@orcl auxiliary sys/oracle@orcl_dg <<EOF
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby1 type disk;
allocate auxiliary channel stby2 type disk;
allocate auxiliary channel stby3 type disk;
allocate auxiliary channel stby4 type disk;
allocate auxiliary channel stby5 type disk;
duplicate target database for standby from active database nofilenamecheck
spfile
  set db_unique_name='orcl_dg'
  set db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl_dg'
  set log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl_dg'
  set control_files='/u01/app/oracle/oradata/orcl_dg/control01.ctl'
  set fal_client='orcl_dg'
  set fal_server='orcl'
  set standby_file_management='AUTO'
  set log_archive_config='dg_config=(orcl,orcl_dg)'
 set log_archive_dest_1='LOCATION=/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl_dg'
  set log_archive_dest_2='SERVICE=orcl lgwr async COMPRESSION=enable VALID_FOR=(online_logfile,primary_role) DB_UNIQUE_NAME=orcl'
  set audit_file_dest='/u01/app/oracle/admin/orcl_dg/adump'
  set diagnostic_dest='/u01/app/oracle'
  SET CLUSTER_DATABASE='FALSE'
  reset remote_listener
  reset local_listener
  reset db_create_file_dest
set undo_tablespace='UNDOTBS1'
;
release channel prmy1;
release channel prmy2;
release channel prmy3;
release channel prmy4;
release channel stby1;
release channel stby2;
release channel stby3;
release channel stby4;
release channel stby5;
}
EOF