Shulou(Shulou.com)06/01 Report--

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'

two。

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'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.