添加standby log
主库参数文件：
CRM.__db_cache_size=8254390272
CRM.__java_pool_size=33554432
CRM.__large_pool_size=33554432
CRM.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from environment
CRM.__pga_aggregate_target=3288334336
CRM.__sga_target=9865003008
CRM.__shared_io_pool_size=0
CRM.__shared_pool_size=1476395008
CRM.__streams_pool_size=0
*.audit_file_dest=’/u01/app/oracle/admin/CRM/adump’
*.audit_trail=’db’
*.compatible=’11.2.0.0.0′
*.control_files=’/dev/rctl1′,’/dev/rctl2′,’/dev/rctl3′
*.db_block_size=8192
*.db_domain=”
*.db_name=’CRM’
*.db_recovery_file_dest=’/u01/app/oracle/fast_recovery_area’
*.db_recovery_file_dest_size=4322230272
*.DB_UNIQUE_NAME=’CRM’
*.diagnostic_dest=’/u01/app/oracle’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=CRMXDB)’
*.LOG_ARCHIVE_CONFIG=’DG_CONFIG=(MES,CRM)’
*.log_archive_dest_1=’location=/u01/app/oracle/fast_recovery_area/CRM/ valid_for=(all_logfiles,all_roles) db_unique_name=CRM’
*.LOG_ARCHIVE_DEST_2=’SERVICE=MES LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=MES’
*.log_archive_dest_state_1=’enable’
*.log_archive_dest_state_2=’enable’
*.open_cursors=300
*.pga_aggregate_target=3288334336
*.processes=150
*.remote_login_passwordfile=’EXCLUSIVE’
*.sga_target=9865003008
*.standby_file_management=’auto’
*.undo_tablespace=’UNDOTBS1′
备库参数文件;
MES.__db_cache_size=8254390272
MES.__java_pool_size=33554432
MES.__large_pool_size=33554432
MES.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from environment
MES.__pga_aggregate_target=3288334336
MES.__sga_target=9865003008
MES.__shared_io_pool_size=0
MES.__shared_pool_size=1476395008
MES.__streams_pool_size=0
*.audit_file_dest=’/u01/app/oracle/admin/MES/adump’
*.audit_trail=’db’
*.compatible=’11.2.0.0.0′
*.control_files=’/dev/rmes_ctl1′,’/dev/rmes_ctl2′,’/dev/rmes_ctl3′
*.db_block_size=8192
*.db_file_name_convert=’/dev/rsystem01′,’/dev/rmes_system01′,’/dev/rusers01′,’/dev/rmes_users01′,’/dev/rsysaux01′,’/dev/rmes_sysaux01′,’/dev/rundotbs01′,’/dev/rmes_undotbs01′,’/dev/rtemp01′,’/dev/rmes_temp01′
*.log_file_name_convert=’/dev/rredo01′,’/dev/rmes_redo01′,’/dev/rredo02′,’/dev/rmes_redo02′,’/dev/rredo03′,’/dev/rmes_redo03′
*.db_domain=”
*.db_name=’CRM’
*.db_recovery_file_dest=’/u01/app/oracle/fast_recovery_area’
*.db_recovery_file_dest_size=4322230272
*.DB_UNIQUE_NAME=’MES’
*.diagnostic_dest=’/u01/app/oracle’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=MESXDB)’
*.LOG_ARCHIVE_CONFIG=’DG_CONFIG=(CRM,MES)’
*.log_archive_dest_1=’location=/u01/app/oracle/fast_recovery_area/MES/ valid_for=(all_logfiles,all_roles) db_unique_name=MES’
*.LOG_ARCHIVE_DEST_2=’SERVICE=CRM LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=CRM’
*.log_archive_dest_state_1=’enable’
*.log_archive_dest_state_2=’enable’
*.open_cursors=300
*.pga_aggregate_target=3288334336
*.processes=150
*.remote_login_passwordfile=’EXCLUSIVE’
*.sga_target=9865003008
*.standby_file_management=’auto’
*.undo_tablespace=’UNDOTBS1′
