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';