Configure Oracle Data Guard Broker | Oracle 12c Data Guard Administration

Oracle Data Guard Broker is a centralized framework that automates the #configuration, #management, and #monitoring of an #Oracle #Data Guard configuration. Oracle Data Guard Broker further enhances Oracle #RAC by providing apply instance failover for Oracle RAC standby #databases. If your apply instance fails, the broker automatically starts recovery on a surviving #instance. With Oracle Database 11g Release 2, seamless database role transitions are now possible with its integration of Oracle #Clusterware.
The Oracle Data Guard Broker can be accessed locally or remotely by using either of the two clients: the command line interface (#DGMGRL) or the Oracle Data Guard page of Oracle Enterprise Manager (#OEM). Once it’s configured, you can modify any attribute of the configuration, monitor the configuration, perform health checks, and perform role changes with a single #command. Truly a wonderful thing.
00:00 What is Data Guard Broker?
04:44 Oracle Data Guard Broker Configuration
05:22 Stop MRP on standby
11:00 Enable broker
12:02 Register primary with broker
23:10 Disable the MRP process
23:59 Stop log shipping from the primary server
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis

[@matheenahamed2692]

Hi sir, can you please make a video for frequently asked questions in interview for Oracle DBA?

[@prasadreddysunkari]

Nice explanation.. thanks for help me to revise this concept...☺️

[@dbagenesis]

Thank you!

[@bikram22tutu]

Have a small question here. though it might be a silly one.
If i have a multi instance primary database hosted on a RAC, can i have a single instance standby database ?

[@seemabankar8116]

If FRA is configured then our archives will go to that location and no need to set log_archive_dest1 but if FRA is not configured you have to set log_archive_dest so that our archive will go to that location ....please correct me if I am wrong.

[@morepankaj25]

What steps need to be done on observer server?

[@seemabankar8116]

Do we have to add static entry for dgmgrl in listener.ora for 19c also?

[@mannanmohammedabdul2707]

If the primary is running on 2 node rac and standby is active dataguard. Does the same steps apply to switch over from primary to standby ?

[@dbagenesis]

Answer is yes and no! Overall it looks same but activity steps will vary.