This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Feb 24, 2013 5:13 AM by user301176 Go to original post RSS
  • 15. Re: DG standby db recovery mode idle, and lag for days.
    user301176 Explorer
    Currently Being Moderated
    but I still not sure how to fix. Not sure where to start. Any more advice?
  • 16. Re: DG standby db recovery mode idle, and lag for days.
    mseberg Guru
    Currently Being Moderated
    So if I'm to catch up.

    You are running on Standby ( new primary ) and the ( old primary ) is considered trashed right?

    If Yes I believe you could try to use RMAN to bring back the Old Primary as the new standby. I think there's a MOS note for this ( searching )

    Later

    This :

    Using RMAN Effectively In A Dataguard Environment. [ID 848716.1] ( has a section on Reinstating a Physical Standby Using Backups )



    Or you could rebuild it ( I probably use RMAN duplicate if possible ).

    Your FLASHBACK DATABASE options appear to be gone.

    What is the size of this?

    Best Regards

    mseberg

    Edited by: mseberg on Feb 22, 2013 1:22 PM
  • 17. Re: DG standby db recovery mode idle, and lag for days.
    user301176 Explorer
    Currently Being Moderated
    Thanks, I will research this oracle note.

    The size of the database around 400g. The flashback are on every database.
  • 18. Re: DG standby db recovery mode idle, and lag for days.
    mseberg Guru
    Currently Being Moderated
    OK. Thanks

    400GB is a fairly quick RMAN duplicate if it comes to that.

    later

    When a failover occurs something happens to the Standby control file - I can't remember if there's any issue or not ( my knee jerk is not ) if you have to rebuild from there. Will check for a note and post here if I find it.

    Not able to find it. Here's another note worth a look :

    Step by Step Guide on How To Reinstate Failed Primary Database into Physical Standby

    Best Regards

    mseberg

    Edited by: mseberg on Feb 22, 2013 2:00 PM

    Edited by: mseberg on Feb 22, 2013 2:14 PM
  • 19. Re: DG standby db recovery mode idle, and lag for days.
    user301176 Explorer
    Currently Being Moderated
    updates:

    I finally got everything working by rebuild the standby (previous primary) from primary(previous standby).

    Now everything works.

    However I want to switchover to the previous primary as Primary.

    Do I have to configure anything to keep it there as primary?

    THanks in advance.
  • 20. Re: DG standby db recovery mode idle, and lag for days.
    CKPT Guru
    Currently Being Moderated
    982335 wrote:
    updates:

    I finally got everything working by rebuild the standby (previous primary) from primary(previous standby).

    Now everything works.

    However I want to switchover to the previous primary as Primary.

    Do I have to configure anything to keep it there as primary?

    THanks in advance.
    Umm, Rebuilding standby is not the right solution. i was not expecting to rebuild the standby. I prefer to troubleshoot and fix the issue. If in case there is no information what i have requested in my previous posts, Then in the worst support we can take advice from Oracle Support.

    So that you, me, all can learn what the issue was exactly behind this. Next time i would suggest to "troubleshoot & Fix" rather than rebuild. :)

    >
    It seems to be network issues and i cannot say exactly.
    I will suggest to post all the Broker log files after issued "reinstate" command ?
    also do refer alert log file for any kind of information.
  • 21. Re: DG standby db recovery mode idle, and lag for days.
    user301176 Explorer
    Currently Being Moderated
    I tried several ways, hooked on the laptop since Wednesday to try to figure it out.

    It seems there were gaps of archivelogs, but v$archive_gap shows nothing .

    The Media recovery was not running. This system not functional right for so many days, I have to get things running for Monday. Because the now primary(standy) is on a very slow network. I got a lot request to get it fixed by users.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points