dataguard issue-archivelogs not getting applied
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: dataguard issue-archivelogs not getting applied

  1. #1
    Join Date
    Jul 2005
    Posts
    87

    dataguard issue-archivelogs not getting applied

    Hi Guys,
    Trying to configure standby(phyiscal) having following issues database version 10g(hp-ux 11.2).

    Here are the output for the following queries.
    SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;

    PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
    --------- ------------ ---------- ---------- ---------- ----------
    ARCH CONNECTED 0 0 0 0
    ARCH CONNECTED 0 0 0 0
    MRP0 WAIT_FOR_GAP 2 10902 0 0

    SQL> select * from v$archive_gap;


    no rows selected
    SQL> SELECT max(sequence#) from v$archived_log where applied='YES';

    MAX(SEQUENCE#)

    select message from v$dataguard_status;

    MESSAGE
    --------------------------------------------------------------------------------
    ARC0: Archival started
    ARC1: Archival started
    ARC0: Becoming the 'no FAL' ARCH
    ARC0: Becoming the 'no SRL' ARCH
    ARC1: Becoming the heartbeat ARCH
    Attempt to start background Managed Standby Recovery process
    MRP0: Background Managed Standby Recovery process started
    Managed Standby Recovery not using Real Time Apply
    Media Recovery Waiting for thread 1 sequence 12335
    Fetching gap sequence in thread 1, gap sequence 12335-12431
    FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence

    MESSAGE
    --------------------------------------------------------------------------------
    FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence
    FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence
    FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence
    FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence
    FAL[client]: Failed to request gap sequence
    GAP - thread 1 sequence 12335-12431
    DBID 1860283776 branch 613346304
    FAL[client]: All defined FAL servers have been attempted.
    MRP0: Background Media Recovery cancelled with status 16037
    MRP0: Background Media Recovery process shutdown
    Managed Standby Recovery Canceled

    MESSAGE
    --------------------------------------------------------------------------------
    Attempt to start background Managed Standby Recovery process
    MRP0: Background Managed Standby Recovery process started
    Managed Standby Recovery not using Real Time Apply
    Media Recovery Waiting for thread 1 sequence 12335
    Fetching gap sequence in thread 1, gap sequence 12335-12431
    FAL[client]: Failed to request gap sequence
    GAP - thread 1 sequence 12335-12431
    11:06AM Artis, Bernard: MESSAGE
    --------------------------------------------------------------------------------
    DBID 1860283776 branch 613346304
    FAL[client]: All defined FAL servers have been attempted.
    MRP0: Background Media Recovery cancelled with status 16037
    MRP0: Background Media Recovery process shutdown
    Managed Standby Recovery Canceled
    Attempt to start background Managed Standby Recovery process
    MRP0: Background Managed Standby Recovery process started
    Managed Standby Recovery not using Real Time Apply
    Media Recovery Log /u01/app/oracle/arch/RUBIS/1_12335_613346304.dbf
    Media Recovery Waiting for thread 2 sequence 10902
    Fetching gap sequence in thread 2, gap sequence 10902-10995

    MESSAGE
    --------------------------------------------------------------------------------
    FAL[client]: Failed to request gap sequence
    GAP - thread 2 sequence 10902-10995
    DBID 1860283776 branch 613346304
    FAL[client]: All defined FAL servers have been attempted.



    Thanks in advance

  2. #2
    Join Date
    Jul 2005
    Posts
    87
    SQL> SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG;

    THREAD# SEQUENCE# APP
    ---------- ---------- ---
    1 12335 NO
    1 12336 NO
    1 12337 NO
    1 12338 NO
    1 12339 NO
    1 12340 NO
    1 12341 NO
    1 12342 NO
    1 12343 NO
    1 12344 NO
    1 12345 NO

    THREAD# SEQUENCE# APP
    ---------- ---------- ---
    1 12346 NO
    1 12347 NO
    1 12348 NO
    1 12349 NO
    1 12350 NO
    1 12351 NO
    1 12352 NO
    1 12353 NO
    1 12354 NO
    1 12355 NO
    1 12356 NO

    THREAD# SEQUENCE# APP
    ---------- ---------- ---
    1 12357 NO
    1 12358 NO
    1 12359 NO
    1 12360 NO
    1 12361 NO
    1 12362 NO
    1 12363 NO
    1 12364 NO
    11:18AM Artis, Bernard: 1 12365 NO
    1 12366 NO
    1 12367 NO

    THREAD# SEQUENCE# APP
    ---------- ---------- ---
    1 12368 NO
    1 12369 NO
    1 12370 NO
    1 12371 NO
    1 12372 NO
    1 12373 NO
    1 12374 NO
    1 12375 NO
    1 12376 NO
    1 12377 NO
    1 12378 NO

    THREAD# SEQUENCE# APP
    ---------- ---------- ---
    1 12379 NO
    1 12380 NO
    1 12381 NO
    1 12382 NO
    1 12383 NO
    1 12384 NO
    1 12385 NO
    1 12386 NO
    1 12387 NO
    1 12388 NO
    1 12389 NO

    THREAD# SEQUENCE# APP
    ---------- ---------- ---
    1 12390 NO
    1 12391 NO
    1 12392 NO
    1 12393 NO
    1 12394 NO
    1 12395 NO
    1 12396 NO
    1 12397 NO
    1 12398 NO
    1 12399 NO
    1 12400 NO

    THREAD# SEQUENCE# APP
    ---------- ---------- ---
    1 12401 NO
    1 12402 NO
    11:18AM Artis, Bernard: 1 12403 NO
    1 12404 NO
    1 12405 NO
    1 12406 NO
    1 12407 NO
    1 12408 NO
    1 12409 NO
    1 12410 NO
    1 12411 NO

    THREAD# SEQUENCE# APP
    ---------- ---------- ---
    1 12412 NO
    1 12413 NO
    1 12414 NO
    1 12415 NO
    1 12416 NO
    1 12417 NO
    1 12418 NO
    1 12419 NO
    1 12420 NO
    1 12421 NO
    1 12422 NO

    THREAD# SEQUENCE# APP
    ---------- ---------- ---
    1 12423 NO
    1 12424 NO
    1 12425 NO
    1 12426 NO
    1 12427 NO
    1 12428 NO
    1 12429 NO
    1 12430 NO
    1 12431 NO
    1 12432 NO
    1 12433 NO

    THREAD# SEQUENCE# APP
    ---------- ---------- ---
    1 12434 NO
    1 12435 NO
    1 12436 NO
    1 12437 NO
    1 12438 NO

    104 rows selected.
    WHERE TESTP-PRIMARY DATABASE
    TESTS STANDBY
    ##Modification to primary##

    *.log_archive_dest_2='SERVICE=TESTS valid_for=(online_logfiles,primary_role) DB_UNIQUE_NAME=TESTS'
    *.db_file_name_convert='/u05/oradata/TESTS','/u05/oradata/TESTP'
    *.log_file_name_convert='/u02/origlog/TESTS','/u02/origlog/TESTP','/u03/mirrlog/TESTS','/u03/mirrlog/TESTP'
    *.fal_client='TESTP'
    *.fal_server='TESTS'
    *.standby_file_management='AUTO'
    *.STANDBY_ARCHIVE_DEST='/u01/app/oracle/arch/db_2/WTEXP'

    ##Modifications to standby##

    TESTP1.__db_cache_size=1392508928
    TESTS.__db_cache_size=1392508928
    TESTP1.__java_pool_size=16777216
    TESTS.__java_pool_size=16777216
    TESTP1.__large_pool_size=16777216
    TESTS.__large_pool_size=16777216
    TESTP1.__shared_pool_size=452984832
    TESTS.__shared_pool_size=452984832
    TESTP1.__streams_pool_size=0
    TESTS.__streams_pool_size=0
    *.archive_lag_target=900
    *.audit_file_dest='/u01/app/oracle/admin/TESTS/adump'
    *.background_dump_dest='/u01/app/oracle/admin/TESTS/bdump'
    *.backup_tape_io_slaves=true
    *.cluster_database_instances=1
    *.compatible='10.2.0.2.0'
    *.control_file_record_keep_time=45
    *.core_dump_dest='/u01/app/oracle/admin/TESTS/cdump'
    *.db_block_size=8192
    *.db_domain=''
    *.db_file_multiblock_read_count=16
    *.db_file_name_convert='/u05/oradata/TESTP','/u05/oradata/TESTS'
    *.db_name='TESTP'
    *.db_recovery_file_dest='/u04/app/oracle/flash_recovery/TESTS'
    *.db_recovery_file_dest_size=2147483648
    *.db_unique_name='TESTS'
    *.fal_client='TESTS'
    *.fal_server='TESTP'
    *.instance_name='TESTS'
    TESTS.instance_number=1
    *.job_queue_processes=10
    *.local_listener='LISTENER_TESTS'
    *.log_archive_config='DG_CONFIG=(TESTP,TESTS)'
    *.log_archive_dest_1='LOCATION=/u01/app/oracle/arch/TESTS VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=TESTS'
    *.log_archive_dest_2='SERVICE=TESTP valid_for=(online_logfiles,primary_role) DB_UNIQUE_NAME=TESTP'
    *.log_archive_format='TESTPARCH_%t_%s_%r.dbf'
    *.log_file_name_convert='/u02/origlog/TESTP','/u02/origlog/TESTS','/u03/mirrlog/TESTP','/u03/mirrlog/TESTS'
    *.open_cursors=300
    *.pga_aggregate_target=200M
    *.processes=1000
    *.remote_listener='LISTENER_TESTS'
    *.remote_login_passwordfile='exclusive'
    *.sessions=225
    *.sga_target=1800M
    *.standby_archive_dest='/u01/app/oracle/arch/TESTS'
    *.standby_file_management='AUTO'
    *.undo_management='AUTO'
    TESTS1.undo_tablespace='UNDO_01'
    *.user_dump_dest='/u01/app/oracle/admin/TESTS/udump'

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    do the logs exist

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence
    This means that you don't have TNS set up correctly on your standby for it to be able to pull the logs across the network once it has discovered a gap. Either:

    Fix your TNS.

    or

    Manually copy the logs across to your standby and register the logs.
    Assistance is Futile...

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