ORACLE 11G (Bare device Dataguard)

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 '

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

ORACLE 11G (Bare device Dataguard)