>Dataguard BROKER -2 dg1 ora değişiklikleri

>primarydg1_initorcl.ora;

orcl.__db_cache_size=385875968
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=213909504
orcl.__streams_pool_size=0
*.archive_lag_target=0
*.audit_file_dest=’C:\oracle\product\10.2.0/admin/orcl/adump’
*.background_dump_dest=’C:\oracle\product\10.2.0/admin/orcl/bdump’
*.compatible=’10.2.0.1.0′
*.control_files=’C:\oracle\product\10.2.0\oradata\orcl\control01.ctl’,’C:\oracle\product\10.2.0\oradata\orcl\control02.ctl’,’C:\oracle\product\10.2.0\oradata\orcl\control03.ctl’
*.core_dump_dest=’C:\oracle\product\10.2.0/admin/orcl/cdump’
*.db_block_size=8192
*.db_domain=”
*.db_file_multiblock_read_count=16
*.db_name=’orcl’
*.db_recovery_file_dest=’C:\oracle\product\10.2.0/flash_recovery_area’
*.db_recovery_file_dest_size=2147483648
*.DB_UNIQUE_NAME=’dg1′
*.db_writer_processes=2
*.dg_broker_start=TRUE
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)’
*.FAL_CLIENT=’dg1′
*.FAL_SERVER=’dg2′
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG=’DG_CONFIG=(dg1,dg2)’
*.LOG_ARCHIVE_DEST_1=’LOCATION=C:\archives
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=dg1′
orcl.log_archive_dest_1=’location=”C:\archives”‘,’valid_for=(ONLINE_LOGFILE,ALL_ROLES)’
*.log_archive_dest_2=’service=”(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=HLD-KAY-DG2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dg2_XPT)(INSTANCE_NAME=dg2)(SERVER=dedicated)))”‘,’ ARCH SYNC NOAFFIRM delay=3 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name=”dg2″ register net_timeout=180 valid_for=(online_logfile,primary_role)’
*.LOG_ARCHIVE_DEST_STATE_1=’ENABLE’
orcl.log_archive_dest_state_1=’ENABLE’
*.log_archive_dest_state_2=’ENABLE’
*.LOG_ARCHIVE_FORMAT=’%t_%s_%r.arc’
orcl.log_archive_format=’%t_%s_%r.arc’
*.log_archive_max_processes=2
*.log_archive_min_succeed_dest=1
orcl.log_archive_trace=127
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.REMOTE_LOGIN_PASSWORDFILE=’EXCLUSIVE’
*.SERVICE_NAMES=’dg1′
*.sga_target=612368384
orcl.standby_archive_dest=”
*.standby_file_management=’AUTO’
*.undo_management=’AUTO’
*.undo_tablespace=’UNDOTBS1′
*.user_dump_dest=’C:\oracle\product\10.2.0/admin/orcl/udump’

primarydg1_2initorcl.ora;
orcl.__db_cache_size=381681664
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=218103808
orcl.__streams_pool_size=0
*.archive_lag_target=0
*.audit_file_dest=’C:\oracle\product\10.2.0/admin/orcl/adump’
*.background_dump_dest=’C:\oracle\product\10.2.0/admin/orcl/bdump’
*.compatible=’10.2.0.1.0′
*.control_files=’C:\oracle\product\10.2.0\oradata\orcl\control01.ctl’,’C:\oracle\product\10.2.0\oradata\orcl\control02.ctl’,’C:\oracle\product\10.2.0\oradata\orcl\control03.ctl’
*.core_dump_dest=’C:\oracle\product\10.2.0/admin/orcl/cdump’
*.db_block_size=8192
*.db_domain=”
*.db_file_multiblock_read_count=16
*.db_name=’orcl’
*.db_recovery_file_dest=’C:\oracle\product\10.2.0/flash_recovery_area’
*.db_recovery_file_dest_size=2147483648
*.DB_UNIQUE_NAME=’dg1′
*.db_writer_processes=2
*.dg_broker_start=TRUE
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)’
*.fal_client='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=HLD-KAY-DG1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dg1_XPT)(INSTANCE_NAME=orcl)(SERVER=dedicated)))’
*.fal_server='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=HLD-KAY-DG2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dg2_XPT)(SERVER=dedicated)))’
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG=’DG_CONFIG=(dg1,dg2)’
*.LOG_ARCHIVE_DEST_1=’LOCATION=C:\archives
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=dg1′
orcl.log_archive_dest_1=’location=”C:\archives”‘,’valid_for=(ONLINE_LOGFILE,ALL_ROLES)’
*.log_archive_dest_2=’service=”(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=HLD-KAY-DG2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dg2_XPT)(INSTANCE_NAME=dg2)(SERVER=dedicated)))”‘,’ ARCH SYNC NOAFFIRM delay=3 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name=”dg2″ register net_timeout=180 valid_for=(online_logfile,primary_role)’
*.LOG_ARCHIVE_DEST_STATE_1=’ENABLE’
orcl.log_archive_dest_state_1=’ENABLE’
*.log_archive_dest_state_2=’ENABLE’
*.LOG_ARCHIVE_FORMAT=’%t_%s_%r.arc’
orcl.log_archive_format=’%t_%s_%r.arc’
*.log_archive_max_processes=2
*.log_archive_min_succeed_dest=1
orcl.log_archive_trace=127
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.REMOTE_LOGIN_PASSWORDFILE=’EXCLUSIVE’
*.SERVICE_NAMES=’dg1′
*.sga_target=612368384
orcl.standby_archive_dest=”
*.standby_file_management=’AUTO’
*.undo_management=’AUTO’
*.undo_tablespace=’UNDOTBS1′
*.user_dump_dest=’C:\oracle\product\10.2.0/admin/orcl/udump’

standbydg1_initorcl.ora;

orcl.__db_cache_size=385875968
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=213909504
orcl.__streams_pool_size=0
*.archive_lag_target=0
*.audit_file_dest=’C:\oracle\product\10.2.0/admin/orcl/adump’
*.background_dump_dest=’C:\oracle\product\10.2.0/admin/orcl/bdump’
*.compatible=’10.2.0.1.0′
*.control_files=’C:\oracle\product\10.2.0\oradata\orcl\control01.ctl’,’C:\oracle\product\10.2.0\oradata\orcl\control02.ctl’,’C:\oracle\product\10.2.0\oradata\orcl\control03.ctl’
*.core_dump_dest=’C:\oracle\product\10.2.0/admin/orcl/cdump’
*.db_block_size=8192
*.db_domain=”
*.db_file_multiblock_read_count=16
*.db_name=’orcl’
*.db_recovery_file_dest=’C:\oracle\product\10.2.0/flash_recovery_area’
*.db_recovery_file_dest_size=2147483648
*.DB_UNIQUE_NAME=’dg1′
*.db_writer_processes=2
*.dg_broker_start=TRUE
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)’
*.fal_client='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=HLD-KAY-DG1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dg1_XPT)(INSTANCE_NAME=orcl)(SERVER=dedicated)))’
*.fal_server='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=HLD-KAY-DG2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dg2_XPT)(SERVER=dedicated)))’
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG=’DG_CONFIG=(dg1,dg2)’
*.LOG_ARCHIVE_DEST_1=’LOCATION=C:\archives
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=dg1′
orcl.log_archive_dest_1=’location=”C:\archives”‘,’valid_for=(ONLINE_LOGFILE,ALL_ROLES)’
*.log_archive_dest_2=”
orcl.log_archive_dest_2=’location=”dgsby_dg1″‘,’valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)’
*.LOG_ARCHIVE_DEST_STATE_1=’ENABLE’
orcl.log_archive_dest_state_1=’ENABLE’
*.log_archive_dest_state_2=’ENABLE’
orcl.log_archive_dest_state_2=’ENABLE’
*.LOG_ARCHIVE_FORMAT=’%t_%s_%r.arc’
orcl.log_archive_format=’%t_%s_%r.arc’
*.log_archive_max_processes=2
*.log_archive_min_succeed_dest=1
orcl.log_archive_trace=127
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.REMOTE_LOGIN_PASSWORDFILE=’EXCLUSIVE’
*.SERVICE_NAMES=’dg1′
*.sga_target=612368384
orcl.standby_archive_dest=’dgsby_dg1′
*.standby_file_management=’AUTO’
*.undo_management=’AUTO’
*.undo_tablespace=’UNDOTBS1′
*.user_dump_dest=’C:\oracle\product\10.2.0/admin/orcl/udump’

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s