CONFIGURE DATAGUARD BROKER IN ORACLE DATAGUARD

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.

https://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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s