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

Add standby log

Main library parameter file:

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'

Prepare the library parameter file

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'

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.