Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2008
    Posts
    24

    Question Unanswered: Phy Standby Database Log sequence not matching with Production

    Hi All,

    There is a Physical Standby database for our Production database in differnet severs. Yesterday the server (Standby database) was rebooted and the standby listner was down. Today morning we made the listner up. Now the log sequence are not matchinng with Production.

    I shutdown the standby database and starup mount and put the command ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT; But no luck...

    The current arch-logs of Production are not preseent at Standby arch-dest. There is a huge gap between Production and Standby arch-logs. I think the archive logs are not transfered to Standby arch dest. Can I do any manual transport (rsync) of the archive-logs of Production to standby.

    Please suggest how to syncronise them.

    Thanks,
    gohappy
    Last edited by gohappy; 12-07-09 at 04:13.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    what clues exist in alert_PRI.log & alert_SNDBY.log files?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink Close the gap.

    You need to first close the gap:

    1) Manually transmit Log Files in the archive gap to the standby

    2) Manually applying Log Files to the Standby

    ALTER DATABASE RECOVER AUTOMATIC STANDBY DATABASE;

    When Oracle database prompts for the name of a log file that does not exist, do a <CTRL/C> to cancel

    3) Restart managed recovery:

    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •