正德厚生,臻于至善

adg_setup.sh

export ORACLE_SID=BZPROD1
rman msglog /home/oracle/work/adg_setup.log << EOF
connect target sys/xxxxxx@BZPRODRPI
connect auxiliary sys/xxxxx@BZPRODDG
run {
allocate channel ch001 type disk;
allocate channel ch002 type disk;
allocate channel ch003 type disk;
allocate channel ch004 type disk;
allocate channel ch006 type disk;
allocate channel ch007 type disk;
allocate channel ch008 type disk;
allocate auxiliary channel ch005 type disk;
duplicate target database for standby from active database NOFILENAMECHECK
spfile
  set db_unique_name 'BZPRODC'
  set db_create_file_dest '+DATA'
  set standby_file_management 'AUTO'
  set remote_listener 'dehetudb-scan:1521'
  set log_archive_dest_2 ''
  set log_archive_dest_state_2 'DEFER'
  set fal_server 'BZPROD1','BZPROD2'
  set fal_client 'BZPRODC'
  set control_files='+DATA/BZPRODC/CONTROLFILE/ctrl1','+DATA/BZPRODC/CONTROLFILE/ctrl2'
  set audit_file_dest '/oracle/app/oracle/admin/BZPRODC/adump'
;
release channel ch001;
release channel ch002;
release channel ch003;
release channel ch004;
release channel ch005;
release channel ch006;
release channel ch007;
release channel ch008;
}
EOF
赞(0) 打赏
未经允许不得转载:徐万新之路 » adg_setup.sh

支持快讯、专题、百度收录推送、人机验证、多级分类筛选器,适用于垂直站点、科技博客、个人站,扁平化设计、简洁白色、超多功能配置、会员中心、直达链接、文章图片弹窗、自动缩略图等...

联系我们

觉得文章有用就打赏一下文章作者

非常感谢你的打赏,我们将继续提供更多优质内容,让我们一起创建更加美好的网络世界!

支付宝扫一扫

微信扫一扫

登录

找回密码

注册