ORA-16532: Data Guard broker configuration does not exist

ORA-16532: Data Guard broker configuration does not exist   

Step 1: Disable broker on  primary

In the Primary site disable the broker and remove the existing configuration

DGMGRL> disable configuration;

Disabled.

DGMGRL> exit

Step 2:  Find the location of the broker configuration file

[oracle@grid1vm1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Mar 5 09:06:44 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> show parameter broker

NAME     TYPE VALUE

------------------------------------ ----------- ------------------------------

dg_broker_config_file1     string +DATA/rs1/rs1_dgbroker_config1.dat

dg_broker_config_file2     string +FRA/rs1/rs1_dgbroker_config2.dat

dg_broker_start     boolean TRUE

Step 3:   Set the dg_broker_start=false

SQL> alter system set dg_broker_start=false;

Step 4: Remove the configuration file from primary

Remove the configuration files

ASMCMD> rm +DATA/rs1/rs1_dgbroker_config1.dat

ASMCMD> rm +FRA/rs1/rs1_dgbroker_config2.dat

Step 5 :  Find the broker  configuration file in standby

In the Standby Site

SQL> show parameter broker

NAME     TYPE VALUE

------------------------------------ ----------- ------------------------------

dg_broker_config_file1     string +FRA/rs1_stb/rs1_dgbroker_config2.dat

dg_broker_config_file2     string +FRA/rs1_stb/rs1_dgbroker_config2.dat

dg_broker_start     boolean TRUE

Step 6 : Alter dg_broker_start= false in standby

SQL> alter system set dg_broker_start=false;

Step 7 :  Remove the broker configuration files in Standby

ASMCMD> rm +DATA/rs1_stb/rs1_dgbroker_config1.dat

ASMCMD> rm +FRA/rs1_stb/rs1_dgbroker_config2.dat

 Step 8 . : Recreate the Broker configuration

DGMGRL> connect /

Connected.

DGMGRL> show configuration;

ORA-16532: Data Guard broker configuration does not exist

Configuration details cannot be determined by DGMGRL

Create the new configuration

DGMGRL> create configuration rs1_dgb as primary database is rs1 connect identifier is rs1_prm;

Configuration "rs1_dgb" created with primary database "rs1"

DGMGRL> add database rs1_stb as connect identifier is rs1_stb maintained as physical;

Database "rs1_stb" added

Step 9  :  Enable the configuration  for the first time

DGMGRL> enable configuration;

Step 10 : Check the configuration file created on the respective location .

In the Primary site after enabling the configuration both files exist in their respective locations

In the Standby site after enabling the configuration both files exist in their respective locations