Single node standby on Primary RAC
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Single node standby on Primary RAC

  1. #1
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well you havent included any information about what you have setup

    your parameters?
    how you created the standby?

    anything?

  3. #3
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    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

  4. #4
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96

    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

  5. #5
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    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
  •  



Click Here to Expand Forum to Full Width