-
Single node standby on Primary RAC
Hi there!!!
I'm running oracle 10.2.04 RAC with 2 nodes. I managed to set up a single node standby using ARCH. Node as thread 1 and node 2 as thread 2. The question is why only thread 1; archives are shipped and not thread2. When I query the v$archived_log with thread#=1 it shows all destination including the standby one. But the same question with thread#=2 does not show standby dest_id. What is wrong here?
Regards
Alex
In god i trust
-
well you havent included any information about what you have setup
your parameters?
how you created the standby?
anything?
-
Production
*.archive_lag_target=0
*.background_dump_dest='/oracle/PRD/saptrace/background'
*.cluster_database=TRUE
*.compatible='10.2.0'
*.control_file_record_keep_time=30
*.control_files='/oracle/PRD/origlogA/cntrl/cntrlPRD.dbf','/oracle/PRD/origlogB/cntrl/cntrlPRD.dbf','/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'
*.core_dump_dest='/oracle/PRD/saptrace/background'
*.db_block_size=8192
*.db_cache_size=8589934592
*.db_domain='WORLD'
*.db_files=254
*.db_name='PRD'
*.db_unique_name='PRD'
*.dg_broker_config_file1='/oracle/PRD/sapdata1/DG_BROKER_CONFIG_1.dat'
*.dg_broker_config_file2='/oracle/PRD/sapdata1/DG_BROKER_CONFIG_2.dat'
*.dg_broker_start=TRUE
*.dml_locks=4000
*.fal_client='PRD'
*.fal_server='STD'
*.FILESYSTEMIO_OPTIONS='setall'
PRD1.instance_name='PRD1'
PRD2.instance_name='PRD2'
PRD1.instance_number=1
PRD2.instance_number=2
*.job_queue_processes=1
PRD1.local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.37.44)(PORT=1527))'
PRD2.local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.37.45)(PORT=1527))'
*.log_archive_config='DG_CONFIG=(PRD,PR1)'
*.log_archive_dest_1='LOCATION=/oracle/PRD/oraarch/PRDarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRD'
*.log_archive_dest_2='SERVICE=STD LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PR1'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
PRD2.log_archive_format='%t_%s_%r.dbf'
PRD1.log_archive_format='%t_%s_%r.dbf'
*.log_archive_max_processes=4
*.log_archive_min_succeed_dest=1
*.log_archive_trace=0
*.log_buffer=1048576
*.log_checkpoints_to_alert=true
*.max_dump_file_size='20000'
*.open_cursors=800
*.optimizer_dynamic_sampling=6
*.optimizer_index_cost_adj=20
*.parallel_execution_message_size=16384
*.parallel_min_servers=10
*.parallel_threads_per_cpu=1
*.pga_aggregate_target=4294967296
*.processes=360
*.query_rewrite_enabled='false'
*.recyclebin='off'
PRD1.remote_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.37.45)(PORT=1527))'
PRD2.remote_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.37.44)(PORT=1527))'
*.remote_login_passwordfile='exclusive'
*.remote_os_authent=true
*.replication_dependency_tracking=false
PRD1.service_names='PRD','PRD1','RAC'
PRD2.service_names='PRD','PRD2','RAC'
*.sessions=720
*.shared_pool_size=1073741824
*.standby_file_management='AUTO'
*.star_transformation_enabled='true'
PRD1.thread=1
PRD2.thread=2
*.undo_management='AUTO'
*.undo_retention=3600
*.undo_tablespace='PSAPUNDO'
PRD1.undo_tablespace='PSAPUNDO_001'
PRD2.undo_tablespace='PSAPUNDO_002'
*.user_dump_dest='/oracle/PRD/saptrace/usertrac
standby
*.db_cache_size=8589934592
*.db_domain='WORLD'
*.db_files=254
*.db_name='PRD'
*.db_unique_name='PRD'
*.dg_broker_config_file1='/oracle/PRD/sapdata1/DG_BROKER_CONFIG_1.dat'
*.dg_broker_config_file2='/oracle/PRD/sapdata1/DG_BROKER_CONFIG_2.dat'
*.dg_broker_start=TRUE
*.dml_locks=4000
*.fal_client='PRD'
*.fal_server='STD'
*.FILESYSTEMIO_OPTIONS='setall'
*.job_queue_processes=1
*.log_archive_config='DG_CONFIG=(PRD,PR1)'
*.log_archive_dest_1='LOCATION=/oracle/PRD/oraarch/PRDarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STD'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
*.log_archive_max_processes=4
*.log_archive_min_succeed_dest=1
*.log_archive_trace=0
*.log_buffer=1048576
*.log_checkpoints_to_alert=true
*.max_dump_file_size='20000'
*.open_cursors=800
*.optimizer_dynamic_sampling=6
*.optimizer_index_cost_adj=20
*.parallel_execution_message_size=16384
*.parallel_min_servers=10
*.parallel_threads_per_cpu=1
*.pga_aggregate_target=4294967296
*.processes=360
*.query_rewrite_enabled='false'
*.recyclebin='off'
*.remote_login_passwordfile='exclusive'
*.remote_os_authent=true
*.replication_dependency_tracking=false
*.sessions=720
*.shared_pool_size=1073741824
*.standby_file_management='AUTO'
*.star_transformation_enabled='true'
*.undo_management='AUTO'
*.undo_retention=3600
*.undo_tablespace='PSAPUNDO'
PRD1.undo_tablespace='PSAPUNDO_001'
PRD2.undo_tablespace='PSAPUNDO_002'
*.user_dump_dest='/oracle/PRD/saptrace/usertrac
OS is linux x86 64 bits ...
Guess this will help
In god i trust
-
RAC and Standby
select distinct dest_id from v$archived_log where thread#=2;
dest_id
------
1
2
3
select distinct dest_id from v$archived_log where thread#=1;
1
2
3
4
why this...and the media recoveryis failing until i copy and register the logs from thread# 2 at destination 4; any help??
I'm running in panic mode.
Alex
In god i trust
-
Hi there!!!
I managed to fix it...sounds there is a bug related to the log_archive_dest_4. I just set up another log_archive_dest and it shows in both thread;
Now i have Two single nodes standby(diferent servers) running for a Primary RAC with 2 nodes.
Thanks
In god i trust
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|