CONFIGURE DATAGUARD BROKER IN ORACLE DATAGUARD

Posted on by kishan1 Minute Read

Check the status of parameter db_broker_start. If it is set to FALSE, then set it to TRUE

kish@PRIM>show parameter dg_broker

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/oracle/product/12.1.0/db/
                                                 dbs/dr1dbx00.dat
dg_broker_config_file2               string      /u01/oracle/product/12.1.0/db/
                                                 dbs/dr2dbx00.dat
dg_broker_start                      boolean     FALSE
kish@PRIM>alter system set dg_broker_start=true;

System altered.

Refer below link for a common error while creating configuration file for broker.

http://alphaoragroup.com/2021/10/05/error-ora-16698-log_archive_dest_n-parameter-set-for-object-to-be-added/

Invoke dgmgrl utility and create configuration file for the broker 

kish@PRIM>!dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/password
Connected as SYSDG.
DGMGRL> create configuration dgb AS primary database IS dbx00 CONNECT IDENTIFIER IS dbx00;
Configuration "dgb" created with primary database "dbx00"

Add the service of standby database as connection identifier

DGMGRL> add database dbx01 AS CONNECT IDENTIFIER IS dbx01 MAINTAINED AS PHYSICAL;
Database "dbx01" added

Enable the configuration to make broker effective. 

DGMGRL> enable configuration;
Enabled.

Verify the configurations of primary and standby 

DGMGRL> show configuration

Configuration - dgb

  Protection Mode: MaxPerformance
  Members:
  dbx00 - Primary database
    dbx01 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 2 seconds ago)

Check the status of primary and standby databases

DGMGRL> show configuration

Configuration - dgb

  Protection Mode: MaxPerformance
  Members:
  dbx00 - Primary database
    dbx01 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 8 seconds ago)

DGMGRL> show database dbx01

Database - dbx01

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 0 seconds ago)
  Apply Lag:          0 seconds (computed 0 seconds ago)
  Average Apply Rate: 15.00 KByte/s
  Real Time Query:    OFF
  Instance(s):
    dbx01

Database Status:
SUCCESS

DGMGRL> show database dbx00

Database - dbx00

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    dbx00_1

Database Status:
SUCCESS

Published by kishan

Desire and obsessive to learn ! Generic technology enthusiast who have dynamic experience in database and other technologies. I have persistence to learn any niche skills faster. Served multiple DBA roles in fortune 500 companies to proactively prevent unexpected failure events. Inclined to take risks,face challenging situations and embrace fear! ***I would like to share my thoughts and ideas to this world !***

Leave a Reply