ORA-16532: Oracle Data Guard broker configuration does not exist

Cause:

I thought dgmgrl is already configured for dataguard. But actually it is not which cause the error

[oracle@dc01x01 ~]$ 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> show configuration
ORA-16532: Oracle Data Guard broker configuration does not exist

Workaround:

Check if the below parameters are enabled

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     TRUE

Create a configuration for primary database and add the database to it.

DGMGRL> create configuration dgb AS primary database IS dbx00 CONNECT IDENTIFIER IS dbx00;
Configuration "dgb" created with primary database "dbx00"
DGMGRL> add database dbx01 AS CONNECT IDENTIFIER IS dbx01 MAINTAINED AS PHYSICAL;
Database "dbx01" added

Enable and verify the configuration

DGMGRL> enable configuration
Enabled.
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

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