DG_BROKER_CONFIG_FILEn

Property	Description
Parameter type	String
Syntax	DG_BROKER_CONFIG_FILE[1 | 2] = filename
Default value	Operating system-dependent
Modifiable	ALTER SYSTEM
Range of values	One filename
Basic	No

DG_BROKER_CONFIG_FILEn (where n = 1, 2) specifies the names for the Data Guard broker configuration files.

Every database that is part of a Data Guard broker configuration has two broker configuration files, which contain entries that describe the state and properties of the configuration (such as the sites and databases that are part of the configuration, the roles and properties of each of the databases, and the state of each of the elements of the configuration). Two files are provided so as to always maintain the last known good state of the configuration.

If DG_BROKER_CONFIG_FILEn is not explicitly defined, then it is set to an operating system-specific default value at instance startup. The parameter can only be altered when the DMON (Data Guard broker) process is not running.

Note:

1. This parameter was introduced in 10g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘DG_BROKER_CONFIG_FILEn’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
dg_broker_config_file1	/oracle/product/10.2.0.2ee /dbs/dr1mydb.dat	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	data guard broker configuration file #1
dg_broker_config_file2	/oracle/product/10.2.0.2ee /dbs/dr2mydb.dat	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	data guard broker configuration file #2

Oracle initializatoin parameters