STANDBY Database log difference from Primary Datbase
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: STANDBY Database log difference from Primary Datbase

  1. #1
    Join Date
    May 2008
    Location
    INDIA
    Posts
    17

    Exclamation STANDBY Database log difference from Primary Datbase

    Hi All,

    My Standby database was running fine. After PROD (Primary) database was bounced, the log difference increased(Gap was 35). Yesterday I managed to send the Production archive logs and register with standby and then the log gap became 5. Today morning I found the log gap is 40.The PROD database is not sending the log file to standby (acrhive location).
    Please help me to troubleshoot this.

    Database: Oracle 10.2.0.4.0
    OS: RHEL 5

    Thanks,
    Gohappy
    Last edited by gohappy; 05-06-2010 at 09:53 AM.
    Oracle's Miracle

  2. #2
    Join Date
    Dec 2002
    Posts
    60
    Are you using DG Broker?. If yes check if the configuration is disabled.

    If no DG Broker then check if the log_archive_dest for the standby location is not DEFERRED.

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