如何重建Dataguard Broker Configuration

郑全

dg broker 配置文件出现问题，如何手工重建。

郑全

Step By Step How to Recreate Dataguard Broker Configuration (文档 ID 808783.1)        转到底部转到底部       

In this Document
        Goal
        Solution
        References

Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.1.0.2 [Release 9.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 17-Feb-2014***
*** Reviewed for Relevance 16-Jul-2015 ***


Goal

Step By Step How to Recreate Dataguard Broker Configuration on Windows and Unix.

Parameters used

dg_broker_start

dg_broker_config_file1

dg_broker_config_file2


Solution

Step 1. Stop broker in both of primary and standby databases (in all instances in case of RAC):
SQL>ALTER SYSTEM SET DG_BROKER_START=FALSE;

Step 2. Drop old broker configuration files from both primary and standby:

Check the location of files using : "show parameter dg_broker_config_file"
By default the broker configuration files will be in "$ORACLE_HOME/dbs" in Unix and "$ORACLE_HOME/database" in Windows.
SQL> show parameter dg_broker_config_file

NAME                   TYPE   VALUE
---------------------- ------ ----------------------------------------
dg_broker_config_file1 string \oracle\product\10.2.0\dbs\dr1PROD10G.dat
dg_broker_config_file2 string \oracle\product\10.2.0\dbs\dr2PROD10G.dat

Drop the files using ASMCMD if files are on ASM:
ASMCMD> cd DATA/PROD10G/
ASMCMD> rm dr1PROD10G.dat
ASMCMD> rm dr2PROD10G.dat

Drop the files using :

Unix
$cd $ORACLE_HOME/dbs
$ rm dr1PROD10G.dat
$ rm dr2PROD10G.dat


Windows
c:\>cd $ORACLE_HOME/database
D:\oracle\product\10.2.0\db_2\database> del dr1PROD10G.dat
D:\oracle\product\10.2.0\db_2\database> del dr2PROD10G.dat

Step 3. Start broker in both of primary and standby (in all instances in case of RAC):
SQL>ALTER SYSTEM SET DG_BROKER_START=TRUE;

Step 4. Connect to DGMGRL on primary: (from instance one in case of RAC)
$dgmgrl
DGMGRL for Linux: Version 10.2.0.3.0 - Production

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

Welcome to DGMGRL, type "help" for information.

DGMGRL> CONNECT sys/<password>;
Connected.

Step 5. Create configuration on primary:
DGMGRL> CREATE CONFIGURATION 'PRODCONF' AS PRIMARY DATABASE IS 'PROD10G' CONNECT IDENTIFIER IS PROD10G;

Configuration "PRODCONF" created with primary database "PROD10G"

Step 6. Add standby in the configuration:
DGMGRL> ADD DATABASE 'STDBY10G' AS CONNECT IDENTIFIER IS STDBY10G MAINTAINED AS PHYSICAL;

Database "STDBY10G" added

Step 7. Enable Configuration:
DGMGRL> ENABLE CONFIGURATION;
Enabled.

Use the SHOW command to verify that the configuration and its databases were successfully enabled and brought online:
DGMGRL> SHOW CONFIGURATION;

Configuration
Name: PRODCONF
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED

Databases:
PROD10G - Primary database
STDBY10G - Physical standby database

Current status for "PRODCONF"
SUCCESS
References
NOTE:454418.1 - Unable To Recreate Data Guard Fast Start Failover Configuration With DGMGRL
NOTE:2010503.1 - 12.1 Data guard Broker(DGMGRL) Enhancements - Complete Reference
NOTE:1583588.1 - 12c Create Dataguard Broker Configuration - DGMGRL
BUG:18610799 - DATA GUARD BROKER DOES NOT MANAGE BLOCK CHANGE TRACKING DURING ROLE SWITCH