Archive logs getting applied on standby & not getting updated on Primary- No Lag
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Archive logs getting applied on standby & not getting updated on Primary- No Lag

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    Archive logs getting applied on standby & not getting updated on Primary- No Lag

    Hello all
    I am facing a situation that I see no documentation about.
    Archive logs are getting applied on remote physical standby but are not getting updated on primary Database.

    I have attempted to reset the process with the following commands but not seeing much improvement.

    alter system set log_archive_dest_state_2 =’defer’;
    alter system set log_archive_dest_state_2 =’enable’;

    I am still looking into this however I was just wondering if you have any suggestion/solution

    STANDBY DATABASE
    =============
    SQL> select * from v$archive_gap;

    no rows selected

    SQL>
    Thanks
    Ablakios
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Did you look at the alert log for the standby database? Are you using dataguard? If so you should verify the settings for fal_server and fal_client.
    this space intentionally left blank

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Cool

    If you are using Dataguard, you need to reset using dataguard commands.

    Besides, if your Oracle version is 11.2.0.1, then there is a dataguard/rman bug and a work-around to fix it.

    If you are NOT using Dataguard, then you are on your own.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    No I am not using Dataguard.
    Thanks for the quick response
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

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