ORA-16571: Data Guard configuration file creation failure

DATAGAURD BROKER configuration failed with error “ORA-16571”

List of Topics (Linux, Database, RAC, EBS)

click on the link for RMAN Datagaurd Configuration Setup

[oraerp@rac1 dbs]$ 
[oraerp@rac1 dbs]$ dgmgrl
DGMGRL for Linux: Version 11.1.0.7.0 - 64bit Production

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

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect lkd/lkjs
Connected.
DGMGRL>
DGMGRL> create configuration DELL as

> primary database is dell_live

> connect identifier is dell_live;

Error: ORA-16571: Data Guard configuration file creation failure

Failed.

DGMGRL> exit

==============================================================================================================

Alert log file message

Tue Apr 04 15:06:00 2017

Data Guard Broker (DMON) failed to save its configuration metadata to file "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1.dat"

Additional information may be found in "/u01/db/tech_st/11.1.0/admin/DELL_rac1/diag/rdbms/dell_live/DELL/trace/drcDELL.log"

==============================================================================================================

[oraerp@rac1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Apr 4 15:51:26 2017

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

Connected to:

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter dg_b

NAME                                 TYPE        VALUE

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

dg_broker_config_file1               string    /u01/app/oracle/product/11.2.0

                                                 /dbhome_1/dbs/dr1.dat

dg_broker_config_file2               string    /u01/app/oracle/product/11.2.0

                                                 /dbhome_1/dbs/dr2.dat

dg_broker_start                      boolean     TRUE

SQL>

SOLUTION:

Verify SPACE, PERMISSION and the files as indicated by the “DG_BROKER_CONFIG {1 | 2} parameters and retry.

SQL>

SQL> alter system set dg_broker_start=FALSE;

System altered.

SQL> alter system set dg_broker_config_file1='/u01/db/tech_st/11.1.0/dbs/dr1.dat' scope=both sid='*';

System altered.

SQL> alter system set dg_broker_config_file2='/u01/db/tech_st/11.1.0/dbs/dr2.dat' scope=both sid='*';

System altered.

SQL>

SQL> alter system set dg_broker_start=TRUE;

System altered.

SQL>

SQL> show parameter dg_b

NAME                               TYPE        VALUE

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

dg_broker_config_file1             string      /u01/db/tech_st/11.1.0/dbs/dr1

                                                 .dat

dg_broker_config_file2             string      /u01/db/tech_st/11.1.0/dbs/dr2

                                                 .dat

dg_broker_start                    boolean      TRUE

SQL>

[oraerp@rac1 dbs]$

[oraerp@rac1 dbs]$ dgmgrl

DGMGRL for Linux: Version 11.1.0.7.0 - 64bit Production

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

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys/sd

Connected.

DGMGRL>

DGMGRL>

DGMGRL> create configuration DELL as

> primary database is dell_live

> connect identifier is dell_live;

Configuration "dell" created with primary database "dell_live"

DGMGRL>

DGMGRL>

DGMGRL> add database dell_stby as

> connect identifier is dell_stby

> maintained as physical;

Database "dell_stby" added

DGMGRL>

DGMGRL>

DGMGRL> enable configuration

Enabled.

DGMGRL>

DGMGRL>

DGMGRL> show configuration

Configuration

  Name:                dell

  Enabled:             YES

  Protection Mode:     MaxPerformance

  Databases:

    dell_live - Primary database

    dell_stby - Physical standby database

Fast-Start Failover: DISABLED

Current status for "dell":

SUCCESS

DGMGRL>

CONCLUSION:

ORA-16571 ISSUE RESOLVED                                                                      

Thanks for Reading.

Regards,

Mohammed Areefuddin.

Suggested Topics :

Linux	DATABASE	RMAN	RAC	EBS
5.7 Install	DATABASE Install		11201 Install	R1226 Install
Open Filer Instl	Active DataGaurd	Rman DataGuard	RAC DataGuard	EBS DataGuard
		RMAN DB CLONE	RAC DB Clone	R1226 Clone
	ASMCMD ASM Migrt	RMAN ASM Migrt		RMAN Clone
	11204 M-Upgrade			11202 EBS Upgrade
	12102 M-Upgrade			12102 EBS UPGRADE
Linux Basics	DATABASE Basics	RMAN Basics	RAC Basic	EBS Basics