This discussion is archived
2 Replies Latest reply: Apr 11, 2013 11:18 AM by 977635 RSS

DG Broker configuration for dest_2

977635 Newbie
Currently Being Moderated
I have a (simple) question regarding using the DG Broker and setting the DEST_2, DEST_3 locations.
Oracle 11.2

Question is if the DEST_2 must include a "service" in its location?

We have a production database configured with DG Broker and on the production side, it has the DEST_2 set to use a service.
however, on the standby database, it does not have a service defined in the DEST_2 location.

Also, on the primary side, it has a physical location defined for dest_3, but on standby, it is blank and not defined at all.
  • 1. Re: DG Broker configuration for dest_2
    mseberg Guru
    Currently Being Moderated
    Hello;

    Yes, the Standby setup is incomplete without a DEST_2 setting. It will not be ready to assume the Primary role in the event of a switchover. Data Broker generally will add DEST_3.

    Without a "service" in its location the two database will not be able to work in both roles.


    Here are my setup notes if it helps :

    http://www.visi.com/~mseberg/data_guard/broker_setup_example.html

    This is the Oracle document you want :

    Oracle® Data Guard Broker 11g Release 2 (11.2) E17023-06


    Best Regards

    mseberg

    Edited by: mseberg on Apr 11, 2013 11:25 AM
  • 2. Re: DG Broker configuration for dest_2
    977635 Newbie
    Currently Being Moderated
    Thank you very much.
    That was the confirmation I was looking for and needed.

    Jim

Legend

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