DATAGUARD搭建脚本.-创新互联

1.duplicate target database

for standby

from active database nofilenamecheck

DORECOVER

spfile

set service_names='CWFOLB'

set db_unique_name='CWFOLB'

set log_archive_dest_1='location=/folarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=CWFOLB'

set log_archive_dest_2='SERVICE=CWFOL LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=CWFOL'

set standby_file_management='AUTO'

set fal_server='CWFOL'

set audit_file_dest='/fol/app/oracle/admin/CWFOLB/adump'

set fal_client='CWFOLB'

set control_files='/foldata/control01.ctl','/folarch/control02.ctl'

set DB_FILE_NAME_CONVERT='/oradata/CWFOL/datafile/acf','/foldata','/oradata/CWFOL/datafile/wms','/foldata','/oradata/CWFOL/datafile/fol','/foldata','/oradata/CWFOL/datafile/eol','/foldata','/orada

ta/CWFOL/datafile/smt','/foldata','/oradata/CWFOL/datafile/pms','/foldata','/oradata/CWFOL/datafile','/foldata'

set LOG_FILE_NAME_CONVERT='/oradata/arch','/foldata','/oradata/CWFOL/onlinelog','/foldata','/oracle/flash_recovery_area/CWFOL/onlinelog','/foldata','/oradata/arch/CWFOL/onlinelog','/foldata'

set db_create_file_dest='/foldata'

set db_recovery_file_dest='/folarch'

set db_recovery_file_dest_size='200G';

2.

duplicate target database

for standby

from active database nofilenamecheck

DORECOVER

spfile

set service_names='CWRPTB'

set db_unique_name='CWRPTB'

set log_archive_dest_1='location=+FRA VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=CWRPTB'

set log_archive_dest_2='SERVICE=CWRPT  LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=CWRPT'

set standby_file_management='AUTO'

set diagnostic_dest='/oracle/orabase/admin/CWRPTB'

set audit_file_dest='/oracle/orabase/admin/CWRPTB/adump'

set fal_server='CWRPT'

set fal_client='CWRPTB'

set control_files='+DATA/cwrptb/controlfile/control01.ctl','+DATA/cwrptb/controlfile/control02.ctl'

set cluster_database='false'

set DB_FILE_NAME_CONVERT='/oradata/rpt','+DATA/cwrptb/datafile','/oradata/smt','+DATA/cwrptb/datafile','/oradata/fol','+DATA/cwrptb/datafile','/oradata/acf','+DATA/cwrptb/datafile','/oradata/eol','+DATA/cwrptb/datafile','/oracle/product/ora11gr2/oradata/CWRPT','+DATA/cwrptb/datafile'

set LOG_FILE_NAME_CONVERT='/arch/CWRPT/onlinelog','+DATA/cwrptb/onlinelog'

set db_create_file_dest='+DATA'

set db_recovery_file_dest='+FRA'

set db_recovery_file_dest_size='400G';

另外有需要云服务器可以了解下创新互联scvps.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。